Data Analyst 4

About the role

The Data Analyst 4 position at Ascendion involves developing, maintaining, and enhancing staffing and workforce planning models. Responsibilities include building and optimizing data pipelines using Azure Data Factory (ADF) and related Azure services, developing analytical solutions and automation using SQL and Python, managing and supporting Azure SQL environments, ensuring data quality, reliability, and scalability, and partnering with business stakeholders to translate workforce planning requirements into analytical solutions.

Responsibilities

• Develop, maintain, and enhance staffing and workforce planning models.
• Build and optimize data pipelines using Azure Data Factory (ADF) and related Azure services.
• Develop analytical solutions and automation using SQL and Python.
• Manage and support Azure SQL environments, including database administration, monitoring, and performance tuning.
• Support data integrations, ETL processes, and reporting solutions.
• Work with tabular data models, including SSAS cubes.
• Ensure data quality, reliability, and scalability across planning and reporting platforms.
• Partner with business stakeholders to translate workforce planning requirements into analytical solutions.

Requirements

• Advanced SQL development and database design expertise.
• Strong Python programming skills for data analysis, automation, and data engineering tasks.
• Experience with Azure SQL Database administration, performance tuning, and troubleshooting Azure Data Factory (ADF) pipeline development and maintenance.
• Experience building and maintaining analytical and forecasting models.
• Familiarity with SQL Server Analysis Services (SSAS) cubes and dimensional modeling.
• Understanding of Azure data platform services and cloud-based data architectures.
• Strong analytical, troubleshooting, and communication skills.

Qualifications

• Bachelor's degree in a technical field such as computer science, computer engineering or related field required.
• 5+ years applicable experience required.

Desired Qualifications

• Advanced SQL development and database design expertise.
• Strong Python programming skills for data analysis, automation, and data engineering tasks.
• Experience with Azure SQL Database administration, performance tuning, and troubleshooting Azure Data Factory (ADF) pipeline development and maintenance.
• Experience building and maintaining analytical and forecasting models.
• Familiarity with SQL Server Analysis Services (SSAS) cubes and dimensional modeling.
• Understanding of Azure data platform services and cloud-based data architectures.
• Strong analytical, troubleshooting, and communication skills.

Top Must-Have Hard Skills

• Advanced SQL development and database design expertise.
• Strong Python programming skills for data analysis, automation, and data engineering tasks.
• Experience with Azure SQL Database administration, performance tuning, and troubleshooting Azure Data Factory (ADF) pipeline development and maintenance.
• Experience building and maintaining analytical and forecasting models.
• Familiarity with SQL Server Analysis Services (SSAS) cubes and dimensional modeling.
• Understanding of Azure data platform services and cloud-based data architectures.
• Strong analytical, troubleshooting, and communication skills.

Pay

The salary range for this position is between $1,37,000 - $1,60,000 annually. Factors which may affect pay within this range may include geography/market, skills, education, experience, and other qualifications of the successful candidate.

Benefits

• Medical insurance
• Dental insurance
• Vision insurance
• 401(k) retirement plan
• Long-term disability insurance
• Short-term disability insurance
• 5 personal days accrued each calendar year. The Paid time off benefits meet the paid sick and safe time laws that pertains to the City/ State
• 10-15 days of paid vacation time
• 6 paid holidays and 1 floating holiday per calendar year
• Ascendion Learning Management System