Overview
Job Summary
Drive data-driven decision-making across the organization by designing, developing, and deploying robust analytical solutions. You will leverage your expertise in SQL, Python, and Power BI to transform complex data into actionable insights, build scalable data models, and create compelling visualizations that empower business stakeholders.
Under the general direction of the Technical Leader and senior engineering personel, with moderate latitude for self-direction, work closely with data engineers, BI analysts, product owners, and business stakeholders to deliver fast, efficient, and scalable analytical products and reporting capabilities for Werfen employees.
Responsibilities
Key Accountabilities
1. Work with the team and business stakeholders to identify requirements, define models, and kickstart new analytical initiatives
2. Develop and maintain complex, scalable data models within our data warehouse/lake environment using SQL. Utilize Python for data manipulation, automation, statistical analysis, and potentially building data transformation scripts to prepare data for analysis
3. Develop and maintain a deep understanding of the company's data assets within the data lake/warehouse, serving as a subject matter expert for data availability, lineage, and quality
4. Select and apply appropriate analytical methodologies and data modeling techniques (e.g., dimensional modeling, statistical analysis, segmentation) to address specific business questions
5. Leverage creative solutions, analytics, and visualization/reporting techniques to enhance knowledge and drive actionable insights that deliver ROI
6. Mentor junior analysts and share best practices in data analysis, modeling, and visualization techniques
7. Champions, promotes, and practices data modeling best practices, code quality, and documentation
8. Works with minimal oversight of the technical leader
Networking/Key relationships
To be determined based on department and project needs, to include interactions such as:
9. Product Owner(s) and Technical Leader for Data Analytics
10. Coordination with the Barcelona Data Group, Werfen IT
11. Engineers and Scientists
Qualifications
Minimum Knowledge & Experience required for the position:
12. Bachelor's degree in a quantitative field such as Computer Science, Engineering, Statistics, Mathematics, Economics, or a related STEM discipline. Master's degree is a plus
13. 5 years of relevant work experience, within the healthcare industry preferred
14. Proficiency in advanced SQL including window functions, CTEs, complex joins, and query optimization.
15. Hands-on experience developing, testing, and deploying data transformation pipelines using dbt (data build tool).
16. Strong proficiency in Python for data analysis, manipulation, and automation (experience with libraries like Pandas, NumPy, Scikit-learn is highly desirable).
17. Expertise in data visualization and building interactive dashboards using Power BI (experience with DAX is essential). Familiarity with other tools like Qlik or Tableau is a plus.
18. AWS, Microsoft Azure cloud computing, familiarity with DataOps principles and Agile methodologies, and Git software versioning, preferred
Skills & Capabilities:
19. Team player, self-motivated, perseverance
20. Strong oral and written skills
21. Experience working with cloud-based data warehouses (e.g., Snowflake, Redshift, BigQuery, Azure Synapse) is highly desirable.
22. Solid understanding of data warehousing principles and dimensional modeling concepts.
23. Analyze business requirements in dialogue with internal stakeholders
24. Strong analytical and problem-solving skills, with a keen attention to detail
25. Proficiency in data analysis tools and programming languages (e.g., SQL, Python, R)
26. Skilled in extracting insights from complex datasets
27. Exhibits excellent time management and prioritization abilities
28. Relevant certifications in data analysis, business intelligence, or data science (e.g., Google Data Analytics, Microsoft Certified: Data Analyst Associate) are a plus
Travel requirements: Less than 10% of the time.
If you are interested in constantly learning and being challenged on a daily basis we encourage you to submit your resume or CV.
Werfen is an Equal Opportunity employer and is committed to a diverse workplace. Werfen strictly prohibits unlawful discrimination, harassment or retaliation based upon an individual’s race, color, religion, gender, sexual orientation, gender identity/expression, national origin/ancestry, age, mental/physical disability, medical condition, marital status, veteran status, or any other protected characteristic as defined by applicable state or federal law. If you have a disability and need an accommodation in relation to the online application process, please contact for assistance.
We operate directly in over 30 countries, and in more than territories through distributors. Annual revenue is approximately $2 billion and more than 7, employees around the world comprise our Werfen