Title: Data Analyst 4

Location: Onsite/Redmond, WA

Job Description

Primary 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.

Required 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.

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
• 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

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

Salary Range: $1,62,000 - 1,72,000 Annually -Factors that 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 [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 pertain to the City/ State] [10-15 days of paid vacation time] [6 paid holidays and 1 floating holiday per calendar year]

Preferred Skills

Azure

• Data Analysis
• Python
• SQL Azure
• SQL