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.


Responsibilities

  • 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


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

Please let the company know that you found this position on this Job Board as a way to support us, so we can keep posting cool jobs.

Similar jobs

Browse All Jobs

Data Engineer

SURGO
June 14, 2024

Data Engineer

SoSafe
June 14, 2024

Team Lead Data Engineer (m/f/d)