Database Developer

Data Engineer PositionHerschend is the world's largest family-held themed attractions company, with a portfolio of over 40 family entertainment brands across North America, including destinations, resorts, theme parks, water parks, immersive experiences, and content enjoyed by audiences worldwide.While each of our family brands offers something unique, all are united by a shared purpose: Bringing Families Closer Together by Creating Memories Worth Repeating®. Our 22,000 passionate hosts make this purpose possible through everyday acts of love and service—what we call Heartspitality®—the intersection of heart and hospitality.As an equal-opportunity employer, we strive to provide environments where every host, guest, and partner feels welcome, valued, and loved. We firmly believe that words and actions matter, which is why all individuals are to be treated equally and with respect.Herschend is seeking a skilled Data Engineer to design, build, and maintain scalable data solutions that support analytics and business intelligence initiatives. This role focuses on implementing modern data architectures, including medallion patterns, to facilitate the delivery of high-quality datasets for reporting and visualization in Power BI. Experience with Microsoft Fabric is a strong plus.Essential Duties & ResponsibilitiesDesign and implement data pipelines following medallion architecture principles.Develop, optimize, and maintain ETL/ELT processes for ingesting and transforming structured and unstructured data.Build and manage data models that support reporting and analytics in Power BI.Collaborate with business stakeholders, analysts, and data scientists to translate requirements into scalable data solutions.Ensure data quality, integrity, and governance across all layers of the data platform.Optimize database performance and troubleshoot issues in Microsoft SQL Server environments.Implement best practices for data security, access control, and compliance.Document data flows, architecture, and processes for maintainability and knowledge sharing.Experience & EducationBachelor's degree in Computer Science or a related field, or equivalent experience.Proven experience as a Data Engineer or in a similar role.Skills & QualificationsStrong hands-on experience with Microsoft SQL Server, including T-SQL, stored procedures, and performance tuning.Experience designing and implementing medallion architecture.Solid experience with Power BI, including dataset modeling, DAX, and report optimization.Proficiency in building and managing ETL/ELT processes using pipelines and Spark.Strong understanding of modern data warehousing concepts and dimensional modeling.Experience working with large datasets and distributed data systems.Excellent problem-solving and communication skills.Preferred: Experience with Microsoft Fabric.Preferred: Experience with data lake technologies and modern data platforms.Preferred: Knowledge of Python, Spark, or similar tools for data processing.Preferred: Exposure to CI/CD practices for data pipelines.Nice to have: Experience with real-time or streaming data pipelines.Nice to have: Certifications related to data engineering or business intelligence tools.Equal Opportunity Employer This employer is required to notify all applicants of their rights pursuant to federal employment laws. For further information, please review the Know Your Rights notice from the Department of Labor.