Data Engineer || Data Analyst || DBA || Canada (Remote)

What you ll be doing

Drive completion of data projects and deliverables including the execution of highly complex data solutions while demonstrating best practices, processes and standards for user story

development, data analysis, architecture, modeling, design, coding, and testing.

Lead or assist in the development, documentation, and maintenance of the enterprise data architecture and its deliverables including the design principles, models, and mappings for

transactional and analytical systems serving both strategic and tactical needs.

Work closely with the business, mapping their most pressing business problems to data and analytic solutions.

Develop data models and data transformation logic. Work with data engineers to implement data pipelines.

Prototype data solutions to enable the measurement or monitoring of key performance indicators.

Collaborate with senior management to understand data needs in support of departmental goals.

Partner with product owners and managers in developing scope, dependencies, estimates, project plans, schedules, status reporting, and issue/risk management.

Become the subject matter expert in multiple data domains.

Responsible for defining company standards around data quality.

Maximize opportunities to implement self-service to allow the business to find the data they need quickly, easily and accurately.

Enable data science team to build ML models by designing and providing high quality data.

Establish and maintain effective and positive relationships with internal and external customers.

What you will need to be successful

BS degree in Computer Science, Engineering, Mathematics, or a related field and 8 years of work experience.

Advanced knowledge in translating business rules to technical data requirements.

Advanced SQL knowledge.

Expertise in building data warehouses.

Advanced knowledge of user story development, data warehouse design and modeling (3rd normal form and dimensional modeling), data integration design and development and/or

performance tuning.

Excellent skills in coordination with multiple teams for project execution and issue resolution.

Demonstrated oral/written communication and presentation skills to effectively communicate complex technical information while inspiring and motivating others.

Advanced problem solving and troubleshooting skills.

Advanced knowledge of work estimation, design review, code review and data testing techniques.

Willingness to play multiple roles for different projects, e.g., data analyst, developer, tester, etc.

Advanced knowledge of big data platforms (e.g., DataBricks, Delta Lake, Apache Spark, Snowflake, Redshift).

Experience with Relational Database Management Systems (e.g., Azure SQL, SQL Server, Oracle, MySQL) and NoSQL databases (e.g., MongoDB).

Knowledge of ETL processing tools (e.g., DBT, Databricks, Python).