Database Administrator

**Position: Database Administrator - Intermediate**

**Location: Toronto, Ontario**

**Duration: Long Term Contract**

**Must Haves**:

- Experience with one or more database technologies
- Experience designing data architecture for new databases
- Experience in monitoring and enforcing database rules
- Experience in developing documentation on data standardization and requirements

**General Skills**
- Excellent analytical, problem-solving and decision-making skills, verbal and written communication skills, interpersonal skills and teamwork skills
- Outstanding consulting and relationship management skills, with proven ability to elicit requirements, develop/consult on options and solutions, and provide effective guidance
- Adept at communicating to both technical and non-technical audiences
- Experience with a range of analytical methods, techniques and tools such as, but not limited to: statistical analysis and modelling, data mining, machine learning and algorithms, natural language processing, and other related disciplines at the specified experience level
- Ability to manipulate and analyze complex, high-volume data from structured and unstructured sources
- Experience developing data extraction, transformation, and load functionality for large relational and multi-dimensional data stores
- Experience designing high quality interfaces to present information in a meaningful way to end users
- Broad understanding of data management, financial and business analysis, database architecture, and information visualization
- Proficiency in query languages and experience constructing complex query statements
- Experience in one or more programming or scripting languages
- Strong investigative and logic skills. Proficiency in mathematics and statistics
- Awareness of emerging Business Intelligence trends and directions
- Experience with analytical software such as R,
- Proficiency with desktop analysis software including Microsoft Excel, Access, VBA, Power BI

The general scope of work for the Database Administrator involves:

- Assisting with the transformation/cleaning of data from a legacy database into a new data warehouse
- Determine appropriate data structure for remaining relevant legacy data
- Develop mapping and transformation rules to align the two databases
- Create data dictionary for new data
- Develop connections with multiple other government databases and develop system to maintain the connection so that it does not go out of date
- Supporting Power BI visualization and report building
- Develop and test any automated data validation tools deemed necessary

**Experience and Skill Set Requirements**

**Database Skills**
- Experience with one or more database technologies
- Proficiency with SQL and experience writing SQL scripts
- Experience designing data architecture for new databases
- Experience in monitoring and enforcing database rules
- Experience cleaning, transforming and joining data
- Experience with dimensional data models
- Subject matter expert in database design of data warehouse or data marts.

**Communication Skills**
- Experience in developing documentation on data standardization and requirements
- Demonstrated consulting and relationship management skills, with proven ability to elicit requirements, develop/consult on options and solutions, and provide effective guidance
- Strong verbal and written communication skills; with both technical and non-technical audiences
- A demonstrated team player with a track record for meeting deadlines

**About Arthur Grand Technologies**:
Arthur Grand Technologies is a leading provider of staffing and technology consulting services. Our company is managed by a team of professionals who have worked for big 5 consulting firms for 20+ years. We are a minority-owned staff augmentation and technology consulting company.

Thank you for considering Arthur Grand Technologies. We look forward to hearing from you soon.

Best Regards,

Munavar Khan

Arthur Grand Technologies Inc

Arthur Grand Technologies is an Equal Opportunity Employer (including disability/vets)

**Job Type**: Fixed term contract