Team / Project Overview:- The team works on Data Center workforce/headcount planning and builds forecasting models, automation tools, and SQL-based solutions.
- The role has a strong Data Engineering + SQL programming focus.
- SQL is particularly important for ensuring data quality and preparing the data required to build and maintain pipelines.
Must Haves:- SQL / SQL Database
- Python
- Azure Data Factory (ADF) Pipelines
- SQL Server Analysis Services (SSAS)
Candidate Profile:- Strong SQL is particularly important.
- Data Engineers with strong SQL programming skills can be considered.
- Candidates can come from different technical backgrounds; the focus is primarily on technical capability rather than workforce-planning experience.
- Workforce planning experience is NOT required.
Explain a typical day in the role.: - 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.
What is the ideal background of a candidate for this role?: - 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
Best vs. Average: - The ideal resume would contain related tech industry experience
Education/Experience:- Bachelor's degree in a technical field such as computer science, computer engineering or related field required
- 5+ years applicable experience required
Salary and Other Compensation:The annual salary for this position is between $156,000 - 163,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: The Company offers the following benefits for this position, subject to applicable eligibility requirements: [medical insurance] [dental insurance] [vision insurance] [401(k) retirement plan] [long term disability insurance [shortterm 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]
Preferred SkillsAzure
- Python
- SQL Azure
- SQL
- ETL
- SSAS
