Job Description
Data Engineer
locations
Ontario, Canada
Nova Scotia
Alberta
British Columbia
Remote, United States
time type
Full time
job requisition id
REQ – 02948
Company : ABC Fitness Solutions
It’s fun to work in a company where people truly BELIEVE in what they’re doing!
We’re committed to bringing passion and customer focus to the business.
Job Description
INTRODUCTION:
The Data Engineer will be responsible for developing and maintaining the integration of data for Data Warehouse product. This person will work within the Data Warehouse team and business departments and management to develop, deploy, and support ABCs mission critical Data Warehouse product.
WHAT YOULL DO:
- Adheres to best practices for design, development, and testing of data integration processes
- Under direction of the reporting manager aligns the ETL environments with operational and business needs and strategies
- Data Assurance of the Model including, data quality, load metrics and ETL Rules
- Gauges the effectiveness and efficiency of existing data integration processes
- Migrate user guide document to project/system wiki page (Confluence) and maintain content in accordance with functionality releases
- Be responsible for the development and maintenance of the data integration infrastructure needed for successful analytic processing, providing data interfaces with external databases, and report production
- Thoroughly assess the business needs behind the requests for new data integration functionality
- Conduct technical analytic work
- Manage data integration operations
- Experience with Snowflake, Analysis Services, PowerBI, and a variety of SQL technologies a plus (MySQL, DB2, Oracle)
WHAT YOULL NEED:
- SQL development skills and experience
- Knowledge of performance tuning in SQL environment
- Knowledge in Kimball Data warehousing concepts a plus
- Knowledge of DataFactory, Azure Synapse Analytics, Stored Procedures, ETL and Loading large amounts of data
- SQL skills required on Windows and/or Unix platform
- 1+ years as Data warehouse developer or tester or 2+ years as an ETL developer or tester
- Experience with DW/relational database executing complex SQL queries
- 2+ years of experience with data integration using ETL tools such as SSIS, DataFactory, or other data integration related tools.
- 7+ years of relevant experience (less years required with degrees)