Analyst/Developer - Power BI specialist
Analyst/Developer - Power BI specialist
Posted on :
22-08-2025
Employer Active
1 Vacancy
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Share
Send me jobs like this
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Job Description
Job Title: Analyst/Developer - Specialty 2 - Power BI specialist
Request #73834-1
Location: Peoria IL
Duration: 6 months
Job Description
Role Definition: Support enhancements to existing Power BI reports by adding new fields and creating measures for improved filtering. Migrate reports from Power BI Report Builder to Power BI Desktop. Develop new reports to support the Interoperability Accreditation Framework (IAF) and Dealer Progress Tracking.
Responsibilities:
- Collaborate with the Caterpillar IT Alation Support team to restructure Snowflake schemas introducing separate Domain and Subdomain fields.
- Update existing Power BI reports to incorporate the new Domain and Subdomain fields.
- Create measures in Power BI to enable roll-up filtering and reporting at both Critical Data Domain and Subdomain levels.
- Propose and design new reports to support the Interoperability Accreditation Framework (IAF) and Dealer Progress Tracking.
- Serve as a subject matter expert in Power BI Desktop and provide knowledge transfer to team members.
- Work independently while proactively seeking clarification when needed.
Skill Descriptors:
- Expertise in Snowflake schema design and restructuring.
- Proficient in Power BI Desktop and Power BI Report Builder.
- Skilled in updating converting and developing Power BI reports.
- Effective collaborator with IT teams to ensure seamless implementation.
- Capable of enhancing data governance evidence at the subdomain level.
- Work independently while proactively seeking clarification.
- Strong Communication skills to provide knowledge transfer to team members.
Positions Contributions to Work Group:
- This role provides Power BI expertise to the Office of Data Excellence supporting the development and enhancement of reports related to Data Governance IT Controls Evidence the Interoperability Accreditation Framework (IAF) and Dealer Progress Tracking.
- The Office of Data Excellence leads Enterprise Data Strategy Enterprise Data Governance and Governance IT Controls.
- This position addresses a critical skill and bandwidth gap within the team.
Education & Experience Required:
- Years of experience: 2- 4 years
- Degree requirement: Bachelors degree in Information Technology Computer Science Data Analytics or a related field
- Do you accept internships as job experience: Yes if they involve substantial Power BI work or relevant data analytics tasks such as:
- Building dashboards or reports
- Working with SQL or data modeling
- Are there past or additional job titles or roles that would provide comparable background to this role: Reporting Analyst BI Developer Data Visualization Specialist
Top 3 Skills
- Advanced Power BI Development
- Expertise in building dashboards reports and data models using Power BI Desktop and Power BI Service.
- Data Modeling & DAX
- Strong understanding of data modeling concepts and proficiency in writing complex DAX queries.
- ETL & Data Integration
- Experience with data extraction transformation and loading (ETL) processes using tools like Power Query or integrating with SQL databases.
Additional Technical Skills
(Required)
- SQL proficiency
- Writing queries stored procedures and optimizing performance.
- Power Query (M Language)
- For data transformation within Power BI.
- Data Warehousing Concepts
- Understanding of snowflake schemas and dimensional modeling.
(Desired)
- Power Platform Integration
- Knowledge of Power Apps and Power Automate.
- REST APIs
- Ability to connect Power BI to external APIs for dynamic data sources.
Soft Skills
(Required)
- Problem-Solving: Proactive approach to identifying and resolving data inconsistencies and proposing effective solutions.
- Knowledge Sharing: Willingness to transfer expertise and mentor team members on Power BI best practices
- Analytical Thinking: Ability to interpret business needs and translate them into actionable insights.
- Communication Skills: Clear articulation of findings to both technical and non-technical stakeholders.
Employment Type
Full-time
Key Skills
Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.
