BI Analyst/Report Developer

job summary:
Responsibilities

Design, build, and maintain data pipelines that ingest and integrate data from multiple sources (e.g., Jira, financial systems, Excel/SharePoint trackers)

Develop and manage ETL/ELT processes to transform raw data into clean, structured datasets consumable by both Power BI and Tableau

Build and maintain data models (star schema, curated datasets) that support consistent reporting across platforms - Enable a unified data layer to support coexistence of Tableau and Power BI during the migration period

Ensure data quality and reliability through validation logic, reconciliation checks, and monitoring of pipeline outputs

Optimize query performance, dataset refresh times, and reporting responsiveness across both BI tools

Support data extraction and structuring from Jira and other operational systems for reporting use

Partner with the Senior Data Analyst to operationalize KPI definitions and business logic within the data layer

Manage data refresh schedules, dependencies, and failures to ensure timely and consistent reporting across platforms

Document data flows, transformations, and mappings to support maintainability and migration from Tableau-based logic to Power BI

location: Malvern, Pennsylvania
job type: Contract
salary: $30.27 - 35.27 per hour
work hours: 8am to 5pm
education: Bachelors

responsibilities:

Responsibilities

• Design, build, and maintain data pipelines that ingest and integrate data from multiple sources (e.g., Jira, financial systems, Excel/SharePoint trackers)
• Develop and manage ETL/ELT processes to transform raw data into clean, structured datasets consumable by both Power BI and Tableau
• Build and maintain data models (star schema, curated datasets) that support consistent reporting across platforms - Enable a unified data layer to support coexistence of Tableau and Power BI during the migration period
• Ensure data quality and reliability through validation logic, reconciliation checks, and monitoring of pipeline outputs
• Optimize query performance, dataset refresh times, and reporting responsiveness across both BI tools
• Support data extraction and structuring from Jira and other operational systems for reporting use
• Partner with the Senior Data Analyst to operationalize KPI definitions and business logic within the data layer
• Manage data refresh schedules, dependencies, and failures to ensure timely and consistent reporting across platforms
• Document data flows, transformations, and mappings to support maintainability and migration from Tableau-based logic to Power BI

qualifications:
SQL Power BI / Tableau / comparable BI tools Excel (advanced) Data validation and reconciliation KPI design and reporting logic Dashboard development Requirements gathering Business process analysis Presentation of findings

Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.

At Randstad Digital, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact [email protected].


Pay offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad Digital offers a comprehensive benefits package, including: medical, prescription, dental, vision, AD&D, and life insurance offerings, short-term disability, and a 401K plan (all benefits are based on eligibility).

This posting is open for thirty (30) days.

Any consideration of a background check would be an individualized assessment based on the applicant or employee's specific record and the duties and requirements of the specific job.