Senior Data Engineer: Medallion Architecture & Power BI

Herschend Family Entertainment Corporation; Peachtree Corners, Northern (GA, KY); Hybrid; USD 90,000 - 135,000; Full time

Job summary

Herschend Family Entertainment Corporation seeks a Data Engineer to design, build, and maintain scalable data solutions for analytics and BI initiatives. The role focuses on medallion architecture and delivering high-quality datasets for Power BI reporting.

The ideal candidate will have experience with MS SQL Server, ETL/ELT, and modern data warehousing concepts, with a preference for familiarity with Microsoft Fabric.

Qualifications

• Bachelor's degree in Computer Science or a related field, or equivalent experience.
• Proven experience as a Data Engineer or in a similar role.

Responsibilities

• Design and implement data pipelines following medallion architecture principles.
• Develop, optimize, and maintain ETL/ELT processes for ingestions and transformations.
• Build and manage data models that support Power BI reporting and analytics.
• Collaborate with stakeholders, analysts, and data scientists to translate requirements.
• Ensure data quality, integrity, and governance across the data platform.
• Optimize SQL Server performance and troubleshoot issues in MS SQL Server environments.
• Implement data security, access control, and compliance best practices.
• Document data flows and architectures for maintainability.

Skills

Power BI

SQL Server

T-SQL

Python Spark

Education

Bachelor's degree in Computer Science or related field

Tools

Spark

CI/CD for data pipelines

Data lake technologies

Job description

Herschend Family Entertainment Corporation seeks a Data Engineer to design, build, and maintain scalable data solutions for analytics and BI initiatives. The role focuses on medallion architecture and delivering high-quality datasets for Power BI reporting.

The ideal candidate will have experience with MS SQL Server, ETL/ELT, and modern data warehousing concepts, with a preference for familiarity with Microsoft Fabric.