Data Engineer

Heritage Christian Services; Sainte-Anne-de-Prescott; On-site; USD 58,000 - 71,000; Full time

Job summary

An established industry player is seeking a Data Engineer to manage and enhance their data environment for Business Intelligence and Analytics. This role involves extracting, integrating, and migrating data across various databases while collaborating with Data Scientists to solve complex data challenges. The ideal candidate will have a strong background in data warehousing, cloud analytics solutions, and proficiency in SQL and programming languages like C#, Java, and Python. Join a forward-thinking team that values equity and justice, and contribute to innovative data solutions that drive impactful decisions.

Qualifications

• 3-5 years of IT experience with a focus on data engineering.
• Expertise in SQL coding and troubleshooting for data processing.

Responsibilities

• Define and lead projects to enhance data workflows with Data Scientists.
• Create, maintain, and optimize data pipelines for specific use cases.

Skills

Data Warehousing

Data Modeling

SQL

C#

Java

Python

Cloud Data Analytics

Agile Methods

Analytical Skills

Problem-Solving Skills

Education

Bachelor's degree in Computer Science

Bachelor's degree in Information Systems

Tools

Azure

AWS

Microsoft SQL Server

Azure Synapse

Job description

Overview

The Data Engineer is responsible for the technology and data environment usedto provide data development, support and administration for the Business Intelligence and Analytics platform, for reporting and analytics for Heritage Christian Services. A data engineer will work on extracting, integrating, and migrating data across new and existing databases, facilitating advanced analytics and data processing capabilities.

Pay for this position: $58461 - $70862 / year

The salary of the finalist selected for this role will be set based on a variety of factors, including but not limited to departmental budgets, qualifications, experience, education, licenses, specialty, and training. The above range represents the organization's good faith and reasonable estimate of the range of possible compensation at the time of posting

Responsibilities

• Advanced Collaboration: Define and lead projects in collaboration with Data Scientists and Engineers to enhance data workflows, implementing cutting-edge solutions to meet complex data challenge
• Build data pipelines: Managed data pipelines consist of a series of stages through which data flows (for example, from data sources or endpoints of acquisition to integration to consumption for specific use cases). Data pipelines must be created, maintained, and optimized as workloads move from development to production for specific use cases. Architecting, creating, and maintaining data pipelines will be the primary responsibility of the data engineer.
• Data Governance: Spearhead the development and enforcement of data management practices, ensuring the highest quality of data in our data lake and compliance with data privacy standards
• Collaborate with Business Intelligence and Analytics team to share knowledge and improve data quality.
• Drive Automation through effective metadata management: The Data Engineer will be responsible for using innovative and modern tools, techniques, and architectures to automate the most-common, repeatable and tedious data preparation and integration tasks to minimize manual and error-prone processes and improve productivity.
• Participate in ensuring compliance and governance during data use:. Data engineer should work with data governance teams (and information stewards within these teams) and participate in vetting and promoting content created in the agency for governance and compliance.

Qualifications

• A Bachelor's degree in Computer Science or Information Systems
• 3-5 years of IT experience
• Experience with Data Warehousing, Data Modeling, Semantic Model Definition or Star Schema construction, required
• Hands-on delivery experience of end-to-end cloud data analytics solutions within Azure or AWS, required
• Knowledge of Microsoft SQL Servers, Azure Synapse or Azure SQL instance
• Experience with one or more of the following C# (Programming Language); Java (Programming Language); Python (Programming Language); SQL (Programming Language) required for sophisticated data processing and API development
• Advanced proficiency in relational database modeling, Data Mart design, SQL development, and performance tuning. Must be expert at SQL coding and troubleshooting.
• Preferably working knowledge of Agile Methods and enterprise Cloud Integration
• Experience with Other diagnosing system issues, engaging in data validation, and providing quality assurance testing
• Excellent communication skills (both written and verbal)
• Excellent interpersonal and technical support skills
• Excellent organizational skills, accuracy and attention to detail
• Strong analytical and problem-solving skills
• Ability to work in a collaborative team environment and ability to complete work within demanding time-lines
• Commitment to effectively handle confidential information

Our Commitment to Equity and Justice

We believe that people are entitled to dignity, respect, equity and justice. We champion a society that removes barriers. We reject racism and discrimination of any kind. We protest systemic and political inequities that marginalize people, recognizing that there is a history of structural racism in the United States. We will continue to learn and change to achieve justice. We know that strength comes from unity.