Data Engineer

Cedar Fair is seeking a Data Engineer at our corporate Charlotte office. The Data Engineer develops and supports centralized corporate data repository, to include large data sets from enterprise applications across the Cedar Fair domain. Deliver easy to consume data sets to the business analyst and aid in dashboard and reporting creation and delivery.

• Develop data transformation processes.
• Work with data and business analyst building consumable data sets.
• Data governance and validation between source application and centralized data store.
• Document and diagram all corporate data flow, ETL, and ELT processes.
• Administrative i.e.. email, meetings.

• Bachelor's degree required in Information Technology.
• Master's degree preferred in Data Engineering. 
• 2-4 years work-related experience required.
• 3 or more years of data architecting (ETL & ELT) . 3+ years of SQL Server or other relational data application. Experience with cloud data lake and data delivery models. Expert in TSQL & ansi SQL. Experience in calling API’s via postman.
• AWS, Qlik, and Visual Cron experience a plus. Working knowledge of dbt Cloud and python a plus.
• Ability to pass a background check, if 18 years of age or older, which may include, but is not limited to, credit, criminal, DMV, previous employment, education and personal references, per Company policy, unless prohibited by federal, state, or provincial law.
• Ability to work nights, weekends, and holiday periods to meet business needs.
• Must possess a valid Driver's License.

#LI-CM1