Description

You will design, develop, and maintain data flows and reporting structures to support business intelligence needs.

Responsibilities

• Develop and maintain data flows from source systems including POS, Dynamics AX, HotSchedules, CrunchTime, and UltiPro.
• Design database structures, SQL views, stored procedures, and tabular models using SSAS on-premises and Azure.
• Build and support reports and dashboards within Power BI, including creating new measures for SSAS models.
• Oversee data store and data mart refresh processes and monitor batch processes to prevent downtime.
• Translate business requirements into logical and physical data models and provide actionable analytical recommendations.

Required Skills

• 7+ years of hands-on experience with SQL Server, including SSIS and Stored Procedures.
• 7+ years of experience writing SQL queries.
• 2+ years of experience with Azure cloud services.
• 2+ years of experience with Power BI.
• 2+ years of experience with Data Analysis Expressions (DAX).
• Proficiency with scripting, including PowerShell and batching.
• Experience with ETL processes involving multiple data sources and transport methods.
• Experience working in multi-location environments.
• Bachelor’s Degree in Information Technology or equivalent working experience.

Preferred Skills

• JAMS experience.

Key Skills

Education

Bachelor’s Degree