Associate II - BI Development

General Position Information

• Reports directly to (Title): Manager or Senior Manager, HR Data Analytics
• Matrix reports to (Title): As applicable based on HR Transformation Analytics portfolio alignment
• Direct Reports: Individual contributor; no direct reports
• Created / Last Revised: -

Position Summary

The Associate II - BI Development is responsible for developing, delivering, documenting, and maintaining trusted analytics products that support the operational effectiveness of the Human Resources Group. This role supports analytics solutions from requirements clarification through data preparation, semantic modeling, visualization, release, adoption, and ongoing support.

The Associate II - BI Development partners with HR Analytics leaders, business analysts, and subject matter experts to translate approved business requirements into governed metrics, scalable data models, intuitive dashboards, automated analytical workflows, and clear technical and user documentation. The role works independently on defined assignments, manages assigned deliverables, identifies and escalates risks or ambiguity, and collaborates with more experienced team members on higher-complexity solutions.

Responsibilities

Delivery Execution

• Support the lifecycle of analytics products from requirements clarification and solution design through development, deployment, adoption, ongoing support, and enhancement.
• Complete assigned deliverables with appropriate direction, translating approved requirements into technical outputs and development tasks.
• Maintain assigned backlog items, communicate progress, and balance new development with production support and technical-debt reduction.
• Identify delivery risks, data limitations, technical dependencies, and unclear requirements and escalate them in a timely manner.
• Review deliverables before release for technical accuracy, usability, data quality, governance alignment, and operational supportability.
• Participate in peer review, knowledge sharing, and the consistent application of documentation, testing, and development standards.

BI Development Analytics Products

• Design, develop, test, publish, maintain, and continuously improve governed dashboards, scorecards, reports, analytical applications, and self-service analytics solutions in Power BI.
• Apply the approved analytics design system, including established standards for layout, navigation, typography, visual hierarchy, color, accessibility, interaction patterns, and reusable components; obtain approval before introducing exceptions.
• Use reusable BI components, templates, measures, and solution patterns that improve consistency, scalability, and development efficiency.
• Perform ad hoc analysis and help convert recurring requests into scalable, automated, and maintainable analytics products when appropriate.
• Support product-adoption monitoring, stakeholder-feedback review, and solution improvements that increase usability, trust, and business value.

Data Preparation, Modeling Quality

• Develop and maintain analytical datasets, dimensional models, and semantic models in BigQuery to provide consistent, reusable, understandable, and performant business metrics.
• Write SQL to transform, combine, validate, reconcile, and analyze large or complex datasets while considering performance, maintainability, and cloud costs.
• Use Python and pandas to profile, cleanse, reshape, validate, reconcile, and analyze data and to automate repeatable data-preparation, quality, and reporting processes.
• Partner with data analysts, data architects, and the Data Office to ensure analytical datasets and models support approved business requirements and BI use cases.
• Execute testing and monitoring for data accuracy, completeness, timeliness, consistency, and usability.
• Investigate data and reporting defects, document findings, and implement or support corrective actions.

Stakeholder Partnership Requirements

• Partner with Business Analysts during requirements clarification to understand business questions, reporting needs, required metrics, solution design, and success measures.
• Support acceptance criteria, user acceptance testing, demonstrations, training materials, release communications, and adoption activities.
• Communicate delivery status, risks, assumptions, dependencies, data limitations, and timelines clearly.

Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.