Data Engineer

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