Title: Data Analyst 4Location: Redmond, WAPrimary 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
Education/Experience:- Bachelor's degree in a technical field such as computer science, computer engineering or related field required
- 5+ years applicable experience 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
Top Must-Have HARD Skills & years of experience for each:- 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
ThanksSalary Range:$1,40,000 - 1,50,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]
Want to change the world? Let us know.
Tell us about your experiences, education, and ambitions. Bring your knowledge, unique viewpoint, and creativity to the table. Let's talk!
Preferred SkillsSQL
- Azure
- Python
- Data Analysis
- SQL Server Analysis Services (SSAS)
- Azure Data Factory (ADF)
- Advanced SQL
- ETL
