Power Bi Developer Jobs in Ames, IA (NOW HIRING)

The Senior Data Analyst turns complex data into clear, actionable insights that drive business outcomes. In this role, you will develop scalable analytics assets, serve as our Power BI expert, and promote the advancement of analytics across our organization. You will independently partner with executive stakeholders on challenging data problems, support BI infrastructure, develop scalable data assets, and conduct exploratory analyses that create new value.
Do you enjoy building systems you can take pride in, discovering insights that create measurable value, and working in a role that is both business-facing and technical? If you want to grow your data career with mentorship, resources, and meaningful ownership, this could be a great role for you.
The primary tools used in this role are Databricks, SQL, R, Power BI, and related Microsoft Fabric capabilities.
Remote hires will be required to travel to our headquarters in Ankeny, IA (company paid) on their first day for orientation.
At this time, we are NOT considering applicants that require immigration sponsorship (additional work authorization or permanent work authorization) now or in the future to work in the United States. This includes, but IS NOT LIMITED TO: F1-OPT, F1-CPT, H-1B, TN, L-1, J-1, etc.
Salary range: $85,000-90,000 plus 10% bonus
Benefits
Our employees enjoy a generous package of benefits that we are thrilled to provide, and feel is part of what makes us different as an employer. We value our team members, and this is one way we can show it.
Benefits include:
-PTO, holiday pay and holiday of choice
-401(k) match
-Life insurance
-Short-term disability
-Health, dental and vision insurance
-Maternity/paternity leave
-Health savings account (HSA)
-Flex spending accounts (FSA) - health and dependent
Position Responsibilities may include, but not limited to

• Support Power BI administration, including workspace governance, access management, deployment practices, and platform standards.
• Architect and publish trusted Power BI datasets, semantic models, and dashboards using DAX and Power Query, applying development standards that improve usability, adoption, and long-term maintainability.
• Adopt and champion BI development standards across the organization, including naming conventions, documentation expectations, quality checks, and release practices.
• Stay current with emerging analytics methodologies, technologies, and capabilities.
• Support high-impact analytics initiatives from problem framing through delivery; quantify value, design robust analyses, and communicate recommendations to business partners and executives.
• Develop analytics products and solutions using Databricks, dbt, custom scripting, and BI tools.
• Implement advanced analytics where applicable, using scalable scripts and Databricks workflows to support modeling, automation, and repeatable analysis.
• Build performant Databricks workflows (notebooks, jobs, SQL Warehouses) to wrangle large datasets, engineer features, and automate recurring analyses.
• Partner with Data Engineering to design scalable data solutions, clarify upstream data requirements, and ensure analytics assets are built on reliable data foundations.
• Own analysis quality through data validation, experiment and study design, sensitivity checks, reproducibility, versioning, and documentation.
• Define and monitor KPIs tying operational reporting directly to business objectives.

Required Skills and Experience

• 4-8 years in analytics roles, including 2+ years leading projects with cross-functional business stakeholders
• 2+ years administering a Power BI or Microsoft Fabric environment, including workspace governance, permissions, deployment practices, and user support.
• Proven impact delivering analytics in complex environments (messy data, ambiguous scope) with measurable business outcomes
• Microsoft Fabric and Power BI: data modeling, DAX, Power Query, semantic models, calculation groups, deployment pipelines, and workspace governance.
• Statistical and financial analytics expertise, including analysis design, interpretation of results, and business case development.
• Expert proficiency in writing production-level SQL with query optimization over large, partitioned tables
• Knowledge of AI-assisted analytics development, and AI-assisted analytics tools
• Versioning and Reproducibility: Git-based workflows; disciplined documentation, and peer review
• Proficiency in R to create reproducible workflows, conduct statistical testing, and develop basic models.
• Executive storytelling: translate complex analyses into clear narratives, recommended actions, and solutions that support decision-making.
• Stakeholder partnership: influence cross-functional partners, set expectations, drive alignment, and maintain trust through clear communication.
• Product mindset: understand and define problem statements, success metrics, and iterate with feedback - drives adoption of analytics products and solutions

Preferred Skills and Experience

• Certifications in Databricks, dbt, Power BI, or cloud platforms (Azure preferred)
• Familiarity with data governance tools and compliance standards
• Product management training or analytics product delivery experience

Physical Requirements

• Repetitive motions that include the wrists, hands and/or fingers
• Sedentary work that primarily involves sitting, remaining in a stationary position for prolonged periods
• Visual perception to perform job including peripheral vision, depth perception, and the ability to adjust focus

We may use artificial intelligence (AI) tools to support parts of the hiring process, such as reviewing applications, analyzing resumes, or assessing responses and identifying potential inconsistencies or verification signals in application materials based on available information. These tools assist our recruitment team but do not replace human judgment. Final hiring decisions are ultimately made by humans. If you would like more information about how your data is processed, please contact us.