Basic Qualifications:
•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.
Education: BS/MS in a quantitative field (Statistics, Data Science, Mathematics, Economics, Computer Science, or related), or equivalent practical experience.
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.
Key Metrics for Success:
•Accuracy and efficiency of SQL based solutions and data pipelines.
•Adoption and impact of Power BI reports dashboards across business units.
•Operational improvements driven by automation and data driven insights.
Job Overview:
We are seeking 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.
•Monitor and troubleshoot data processes, ensuring reliability and accuracy across systems.
•Partner with cross functional teams on strategic projects and operational initiatives.
- **Only those lawfully authorized to work in the designated country associated with the position will be considered.**
- **Please note that all Position start dates and duration are estimates and may be reduced or lengthened based upon a client’s business needs and requirements.**
The interactions that I have had with your representatives have always been prompt and very professional. I am very pleased and impressed with your company and services.
Sioe, Consultant
I believe the best thing that Rose HR has going for it is the incredible responsiveness. Everyone is very quick to reply to any concerns, and contacts the contracted employees very quickly and efficiently.
Kevin, Consultant
Each time I contacted Rose, I was completely satisfied with the great attention and customer service I received. Each person was extremely knowledgeable and patient with my concerns or questions.
Diana, Consultant
You are customer service oriented. No matter whether it was the Recruiter or someone in Human Resources/Payroll, you were responsive. That to me is key!
Tonya, Consultant
Your team at Rose International is always very helpful and responsive.
Barbara, Consultant
EMPLOYEE COMMENTS