Cypress HCM · 20 hours ago
Data Analyst
Cypress HCM is the world’s largest professional network, built to help members of all backgrounds and experiences achieve more in their careers. They are seeking a Data Analyst with deep expertise in SQL Server to design, build, and maintain robust data solutions that support critical business operations. The role involves developing SQL Server objects, maintaining Power BI reports, and building data pipelines in Azure Data Factory.
Human ResourcesInformation TechnologyStaffing Agency
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
Monitor and troubleshoot data processes, ensuring reliability and accuracy across systems
Partner with cross functional teams on strategic projects and operational initiatives
Qualification
Required
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 (T-SQL) including stored procedures, views, functions, indexing, and query optimization
2+ years of experience with data integration platforms (Azure Data Factory, SSIS, Boomi, etc.), with a preference for Azure Data Factory (pipelines, datasets, data flows)
2+ years of experience building and maintaining Power BI dashboards/reports (data modeling, DAX/Power Query, refresh strategies, governance)
2+ years of experience working in or supporting operations based workforce teams, with strong understanding of operational processes and data needs
Experience using Git for version control, including common workflows such as branching, committing, pushing, and submitting pull requests for code review and merge
Strong analytical/problem-solving skills and the ability to communicate insights clearly to both technical and non-technical audiences
Preferred
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