Swoon
Our leading tech client is looking for a Data Analyst with deep expertise in SQL Server to design, build, and maintain robust data solutions that support critical business operations. This role focuses on developing tables, views, and stored procedures; creating and maintaining Power BI reports; and building pipelines and automations in Azure Data Factory. The ideal candidate will combine strong technical skills with analytical thinking to deliver scalable, data‑driven solutions.
Key Responsibilities
- Design, develop, and maintain SQL Server objects including tables, views, stored procedures, and functions.
- Optimize queries and ensure database performance, integrity, and security.
- Build and maintain Power BI dashboards and reports to support evolving business needs.
- Develop and manage data pipelines and workflows in Azure Data Factory for efficient data movement and transformation.
- Collaborate with stakeholders to gather requirements and translate them into actionable data solutions.
Basic Qualifications
- BS/MS in a quantitative field (Statistics, Data Science, Mathematics, Economics, Computer Science, or related), or equivalent practical experience.
- 6+ years of experience with SQL (MS SQL Server, Teradata, Oracle, MySQL), with a preference for Microsoft SQL Server (TSQL) including stored procedures, views, functions, indexing, and query optimization.
- 2+ years of experience with data integration platforms, with a preference for Azure Data Factory (pipelines, datasets, data flows).
- 2+ years of experience building and maintaining Power BI dashboards/reports.
- 2+ years of experience working in or supporting operations‑based workforce teams, with strong understanding of operational processes and data needs.
- Strong analytical/problem‑solving skills and the ability to communicate insights clearly to both technical and non‑technical audiences.
Preferred Qualifications
- Exposure to Power Automate for workflow automation.
- Familiarity with data lake platforms (e.g., Hadoop) and orchestration tools like Apache Airflow.
- Experience with big data technologies (e.g., Spark) and scripting languages (Python, R).
- Knowledge of workforce planning, scenario analysis, and optimization techniques.
- Strong communication skills to present findings to both technical and non‑technical audiences.
Seniority level
Not Applicable
Employment type
Contract
Job function
Analyst
Industries
Technology, Information and Media