General/Position Summary
The Business Analyst - HR Data & Data Warehouse plays a key role in supporting Vertexs HR Data Strategy by translating business needs into data and systems requirements. This role will support the design build and validation of HR data/metrics within the enterprise data warehouse ensuring alignment with HR data governance standards. The analyst will collaborate cross functionally to enhance data quality improve data management processes and enable analytics that advance functionally-functionally to enhance data quality improve data management processes and enable analytics that advance organizational goals.
Key Duties & Responsibilities
Partner with HR IT and Data Engineering teams to gather analyze and document business requirements for HR data in the enterprise data warehouse.
Perform detailed process analysis to understand current state data flows and define state data flows and define future-state data flows and define futurestate-state processes aligned with HR data governance.
Translate business requirements into technical specifications for data modeling ETL design and data validation activities.
Support Snowflake based-based data warehouse development by writing SQL queries for data exploration profiling validation and testing.
Conduct data quality assessments develop validation rules and facilitate issue resolution to ensure accuracy and integrity of HR data.
Collaborate with HR Data Governance leads to operationalize data standards definitions and controls within the data warehouse environment.
Document processes data mapping and functional specifications to ensure clarity transparency and long-term-term maintainability.
Assist in evaluating and integrating data cataloging and metadata management tools to enhance data discoverability and governance.
Provide analytical support to HR and business partners enabling data driven-driven insights through validated and trusted datasets.
Required Education Level
Bachelors degree in business Information Systems Data Analytics Human Resources or related discipline.
Required Experience
Requires 5 years of experience as a Business Analyst or Data Analyst (or equivalent combination of education and experience).
Experience working with HR systems HR data models or enterprise data platforms is strongly preferred.
Prior experience supporting data warehouse data governance or metadata initiatives is highly desirable.
Required Knowledge & Skills
Strong business analysis and process analysis skills.
Proficiency in SQL and experience working in Snowflake or similar cloud data warehouse platforms.
Experience performing data validation data profiling and root cause analysis for data quality issues.
Ability to translate complex business needs into structured requirements user stories and documentation.
Hands-on experience in reporting and visualization tools like PowerBI Tableau etc
Excellent communication and collaboration skills to partner with cross f-functional HR and Data teams.
Ability to manage shifting priorities in a fast paced dynamic environment-paced dynamic environment.
Experience with data cataloging or metadata management tools (e.g. Alation Collibra) is a plus.
Other Requirements
Familiarity with People Data HR Data Governance frameworks or data stewardship practices preferred.
No certifications required; data or analytics related-related certifications are a plus.
$70-$80/HR
This job posting is for a temporary role with a third-party agency partner on assignment at Vertex Pharmaceuticals (Vertex). The individual selected for this role will be offered the role as an employee of a third- party agency partner; compensation medical benefits fringe benefits and other terms and conditions of employment shall be presented by the third-party agency partner upon offer. The pay rate range provided is a reasonable estimate of the anticipated compensation range for this job at the time of posting. The actual pay rate will be based on a number of factors including skills competencies experience location and/or being pursued and other job-related factors permitted by addition this role will be eligible for overtime pay in accordance with federal and state requirements
By applying for this position you agree to the Atrium Terms and Conditions and you direct Atrium to share your application materials which may include your CV/Resume email address or phone number with Vertex. For more information on how Vertex handles your personal data related to your job application please see Vertexs Careers Privacy Notice. Agreeing to the Atrium Terms and Conditions includes permission to use the email address and mobile phone number you provide during the application process or throughout the duration of your prospective or actual employment to notify you of job openings profiles articles news and other employment-related information as well as to notify you of special promotions or additional products and services offered by us or our affiliates and partners
(collectively Atrium Alerts). Atrium Alerts may be sent by email phone or text message. Your personal information will be safely stored within the Atrium & Vertex databases. Atrium does not sell your personal information to third parties. Text message and data rates may apply. To OPT OUT of text messaging or to modify your communication preferences for Atrium Alerts at any time please contact Atrium at .
If you do not agree with the Atrium Terms and Conditions you can still complete your application for this position by emailing your resume to our team at Please include the job title in the subject of your email.
No C2C or Third-Party Vendors
Required Experience:
IC