Job Description

Position Description

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


  • Collaborate with cross-functional teams to understand data requirements to 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, Python, C# in line with well-established architectural standard 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 and analytics teams to understand 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
  • Design, implement, and document 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
  • 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 Microsoft Fabric a plus


  • 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

Application Instructions

Please click on the link below to apply for this position. A new window will open and direct you to apply at our corporate careers page. We look forward to hearing from you!

Apply Online