ETL and BDX Developer

Robotics Prcocess Automation, LLC; Northern (KY); Hybrid; USD 90,000 - 120,000; Full time

Job summary

ROBOTIC PROCESS AUTOMATION LLC is seeking a seasoned ETL and BI Developer to design and maintain Power BI dashboards and data models. You will collaborate with stakeholders to translate business needs into robust data solutions and optimize report performance.

The role requires 7–10 years of experience, strong DAX skills, and hands-on work with Power Query, data flows, and diverse data sources. Join a team focused on scalable analytics and data integrity.

Qualifications

• 7–10 years of total experience in BI development.
• Proven ability to design robust data models and data integration.
• Strong experience with Power BI reports, dashboards, and datasets.
• Experience with DAX expressions for measures and KPIs.

Responsibilities

• Develop and maintain Power BI dashboards, reports, and datasets.
• Collaborate with stakeholders to gather and analyse business requirements.
• Design robust data models using Power BI and underlying data sources.
• Write complex DAX expressions for calculated columns, measures, and KPIs.
• Optimize performance of Power BI reports and data models.
• Integrate Power BI with SQL Server, Azure, SharePoint, and other sources.
• Implement row-level security and data access control.
• Automate data refresh schedules and troubleshoot refresh failures.
• Mentor junior developers and conduct code reviews.
• Work with data engineering to ensure data accuracy and integrity.
• Experience with Power Query and data flows.

Skills

Stakeholder collaboration

Analytical thinking

Mentoring

Data quality

Tools

Power BI

DAX

SQL Server

Azure

SharePoint

Power Query

Data Flows

Job description

Role: ETL and BDX Developer (NTTJP00099122)

Required Qualifications & Job Responsibilities:

• Total Exp: 7 10 Yrs.
• Develop and maintain Power BI dashboards, reports, and datasets.
• Collaborate with stakeholders to gather and analyse business requirements.
• Design robust and scalable data models using Power BI and underlying data sources.
• Write complex DAX expressions for calculated columns, measures, and KPIs.
• Optimize performance of Power BI reports and data models.
• Integrate Power BI with other data sources (SQL Server, Excel, Azure, SharePoint, etc.).
• Implement row-level security and data access control.
• Automate data refresh schedules and troubleshoot refresh failures.
• Mentor junior developers and conduct code reviews.
• Work closely with data engineering teams to ensure data accuracy and integrity.
• Exp working on Power Query and data flows.

ROBOTIC PROCESS AUTOMATION LLC is an equal opportunity employer inclusive of female, minority, disability and veterans, (M/F/D/V). Hiring, promotion, transfer, compensation, benefits, discipline, termination and all other employment decisions are made without regard to race, color, religion, sex, sexual orientation, gender identity, age, disability, national origin, citizenship/immigration status, veteran status or any other protected status. ROBOTIC PROCESS AUTOMATION LLC will not make any posting or employment decision that does not comply with applicable laws relating to labor and employment, equal opportunity, employment eligibility requirements or related matters. Nor will ROBOTIC PROCESS AUTOMATION LLC require in a posting or otherwise U.S. citizenship or lawful permanent residency in the U.S. as a condition of employment except as necessary to comply with law, regulation, executive order, or federal, state, or local government contract