Abrar Admin

Mellott Company

<div><div><b>Power BI Developer / Data Analyst</b></div><div>
Full-Time or Freelance | Hybrid or Remote | Warfordsburg, PA</div><div><h1 class="jobSectionHeader"><b>
Role Summary</b></h1></div><div>
We are seeking an experienced Power BI Developer / Data Analyst to design, build, and maintain enterprise-grade Power BI reports and dashboards. The ideal candidate has hands-on experience connecting Power BI to Oracle or other on-premises databases, a strong command of DAX, and the ability to translate complex operational data into clear, actionable visualizations for both executive and operational audiences.</div><div>
This role works closely with the Director of IT and business stakeholders to prioritize and deliver reporting across Sales, Operations, Finance, and Executive dashboards.</div><div></div><div><h1 class="jobSectionHeader"><b><br>
Key Responsibilities</b></h1></div><div><ul><li>
Design and develop Power BI reports, dashboards, and datasets meeting business and executive requirements</li><li>
Connect Power BI to on-premises Oracle 19c (via on-premises data gateway) and other data sources including M365 and Azure</li><li>
Write optimized DAX measures, calculated columns, and complex time-intelligence formulas</li><li>
Build and maintain Power BI dataflows, datasets, and scheduled refresh pipelines</li><li>
Collaborate with the Director of IS and department heads to gather requirements and iterate on deliverables</li><li>
Ensure report performance, data accuracy, and consistent visual standards across the BI environment</li><li>
Document data models, measures, and report logic for maintainability</li><li>
Support row-level security (RLS) configuration and workspace/app publishing in Power BI Service</li><li>
Assist in data governance decisions as needed</li></ul></div><div></div><div><h1 class="jobSectionHeader"><b><br>
Required Qualifications</b></h1></div><h2 class="jobSectionHeader"><b>
Technical Skills</b></h2><div><ul><li>
3+ years of hands-on Power BI development experience (reports, datasets, dataflows, service)</li><li>
Expert-level DAX &mdash; time intelligence, CALCULATE, iterators, measures vs. calculated columns</li><li>
Strong Power Query / M language for data transformation</li><li>
Experience connecting Power BI to Oracle SQL and other data sources such as data lakes</li><li>
Solid understanding of data modeling: star schema, relationships, cardinality</li><li>
Experience publishing and managing reports in Power BI Service (workspaces, apps, RLS)</li><li>
Comfortable working with source control, GitHub, pbip files</li></ul></div><div></div><h2 class="jobSectionHeader"><b><br>
Soft Skills &amp; Working Style</b></h2><div><ul><li>
Ability to translate ambiguous business requirements into clean, intuitive visualizations</li><li>
Strong attention to detail &mdash; accurate data and reliable refresh schedules are non-negotiable</li><li>
Self-directed and comfortable working independently in a lean IS environment</li><li>
Good written communication for documentation and async stakeholder updates</li><li>
Able to give clear timelines of deliverables</li></ul></div><div></div><div><h1 class="jobSectionHeader"><b><br>
Preferred Qualifications</b></h1></div><div><ul><li>
Experience with IFS ERP (any version) or similar industrial ERP systems</li><li>
Familiarity with SQL &mdash; particularly Oracle SQL &mdash; for query optimization and data validation</li><li>
Microsoft Fabric or Power BI Premium / Fabric capacity experience</li><li>
Power BI embedded analytics or paginated reports (SSRS/RDL)</li><li>
Experience supporting industrial companies</li><li>
Microsoft PL-300 (Power BI Data Analyst) certification</li></ul></div></div>

Power BI Developer/Data Analyst

Join Mellott Company and explore 1   exciting career opportunities. They're hiring for various roles with options for remote or on-site work. Apply today and become part of their innovative team.

Mellott Company

About Company

Power BI Developer/Data Analyst