Data Warehouse Engineer

Data Warehouse Engineer

Position

The Data Warehouse Engineer will play a crucial role in designing, implementing, and maintaining our organization's data warehouse infrastructure. This role will contribute to the efficient storage, retrieval, and analysis of data, enabling informed decision-making across our organization.

Responsibilities

* Collaborate with cross-functional teams to understand data requirements and design efficient data warehouse solutions

* Develop and maintain a robust data warehouse architecture that ensures scalability, performance, and data integrity

* Implement pipelines to move raw data in Azure Synapse using Azure Data Factory, SQL, PySpark, C# in line with well-established architectural standards related to Data Lakehouse and Data Warehouse modeling standards

* Data Quality Assurance - ensure data accuracy, consistency, and integrity throughout all processes, and implement data governance best practices.

* Monitor and tune the data warehouse performance to ensure optimal query execution and data retrieval times

* Identify and resolve bottlenecks in the ETL pipelines and data warehouse infrastructure

* Develop and maintain data models, including dimensional and star schemas, to support efficient querying and reporting

* Collaborate with reporting teams to understand reporting requirements and translate them into effective data structures

* Implement security measures to protect sensitive data within the data warehouse

* Work closely with developers, analysts, and other stakeholders to understand their data needs and provide necessary support

* Document data warehouse processes, data dictionaries, and ETL workflows for knowledge sharing and future reference

* Designs, implements, and documents data architecture and data modeling solutions

* Participate with Data Analyst(s) as needed to define minimal viable data assets in support of the visual needs.

* Review and provide architectural guidance for analytic solutions

* Interpret requirements provided by Business and Data Analysts, acting as a liaison with the business to promote smooth development execution

* Triage and troubleshoot data anomalies submitted by the user community

Knowledge, Skills, & Abilities

* Experience with ETL tools and techniques for data integration

* Strong understanding of data modeling concepts, including dimensional modeling and normalization

* Strong communication skills to collaborate with technical and non-technical stakeholders

* Experience with version control systems (e.g., Git) and agile development methodologies is a plus

* Experience in Python/PySpark notebooks

* Experience in Azure Data Factory or SSIS, Azure DW, Azure Data Lake, and Power BI

* Experience with Machine Learning and Artificial Intelligence a plus

Requirements

* Proven experience as a Data Warehouse Engineer or in a similar role

* Practical experience in Python related to data engineering (spark, pandas, etc)

* Practical experience in SQL related to data engineering

* Proficiency in designing and implementing data warehouse solutions using technologies such as MS SQL databases and Azure Synapse or other cloud-based data warehousing services

* Ability and initiative to learn and research new concepts, ideas, and technologies quickly

* Ability to work independently as well as function as an integral part of a team, take initiative and contribute in a fast-paced environment

Why Work for Flynn?

Flynn Group offers a variety of benefits and perks to encourage and empower our employees. We are committed to helping each employee work and live to his or her fullest potential. We offer a variety of benefits and perks while working for us:

* Medical/Dental/Vision

* Retirement and Savings Plan

* Short- and Long-Term Disability

* Basic Life Insurance

* Voluntary Life Insurance

* Tuition Reimbursement

* Paid Time Off

* Flexible/Hybrid Work Schedules

* Company Outings

* Dining Discounts

* PC/Laptop Purchase Assistance

* On-Site Fitness Center

* On-Site Daycare

* On-Site Café

* FUN Work Environment!

The Flynn Group is an Equal Opportunity Employer