Software Engineer - Power BI and Analytics
The Power BI & Analytics Engineer will be an integral member of the Software Development team and will be responsible for developing governed semantic models, dashboards, reports, and self-service analytics solutions.
- Forth Worth, Texas, United States
- Full-time
- Hybrid
- Posted Oct 29, 2026
INDUSTRYSoftware & InternetData & Analytics
Responsibilities
- Analytics Solution Design
- Work with business owners and subject-matter experts to understand reporting needs, business processes, data requirements, and expected outcomes
- Translate business requirements into dashboards, reports, governed semantic models, KPIs, and self-service analytics solutions
- Design dimensional data models that support accurate calculations, reporting performance, usability, and future expansion
- Define relationships, hierarchies, measures, calculated columns, and business logic within semantic models
- Evaluate available enterprise data sources and determine the appropriate source for each analytics solution
- Participate in peer design reviews and incorporate feedback from business and technical teams
- Power BI Development
- Develop Power BI dashboards, reports, semantic models, scorecards, and executive analytics
- Develop and maintain DAX measures, calculated columns, Power Query transformations, hierarchies, filters, bookmarks, and drill-through experiences
- Create reusable calculations, measures, parameters, and reporting components where appropriate
- Connect Power BI solutions to approved SQL databases, data warehouses, Microsoft Fabric, Snowflake, APIs, application systems, and other enterprise data sources
- Develop reports that support both detailed operational analysis and summarized executive-level reporting
- Modify and enhance existing dashboards, reports, semantic models, and data connections as business needs change
- Troubleshoot and resolve report, model, calculation, data, refresh, connectivity, and performance issues
- Evaluate the use of embedded Power BI, custom visuals, and other specialized capabilities when appropriate for the business need
- Dashboard Design and Data Storytelling
- Design dashboards and reports that clearly communicate performance, trends, exceptions, risks, and opportunities
- Select visualizations that appropriately represent the underlying data and intended business message
- Organize report layouts, navigation, filters, drill-through capabilities, and interactions to support usability
- Apply consistent design standards, terminology, calculations, and formatting across analytics solutions
- Balance the need for detailed information with the need for clear and concise reporting
- Design reports for the intended audience, including operational users, business managers, and executives
- Work with business users to confirm that reports provide the information needed to support decisions and daily operations
- Data Modeling and Transformation
- Develop dimensional models using appropriate fact tables, dimension tables, relationships, hierarchies, and levels of detail
- Use Power Query to connect, cleanse, transform, combine, and prepare data for analytics
- Develop DAX calculations that accurately represent approved KPIs, business rules, and reporting requirements
- Evaluate model size, relationship design, data granularity, and calculation complexity to support performance and maintainability
- Identify and address data-quality issues that may affect reports, calculations, or business decisions
- Coordinate with data warehouse, application, and Data & Analytics resources when source-system or upstream data changes are needed
- Reuse FALv3 definitions and certified enterprise data where available rather than recreating existing business logic or data sources
- Data Validation and Reconciliation
- Develop and document test scenarios to validate data models, transformations, DAX measures, filters, security, and reporting results
- Reconcile report results to approved source systems, enterprise data warehouses, and existing business records
- Investigate and resolve differences between analytics results and source or operational systems
- Validate calculations, KPIs, assumptions, filters, and expected results with business owners before deployment
- Confirm that reports behave as expected under different filters, user roles, drill-through paths, and reporting scenarios
- Retest analytics solutions following changes to data sources, calculations, models, business rules, or security
- Clearly explain calculations, data sources, assumptions, and reconciliation results to business users
- Security and Access Management
- Configure and maintain row-level security and other Power BI access controls
- Manage or support Power BI workspaces, applications, audiences, permissions, and content distribution
- Validate that users can access the appropriate reports and data based on their assigned roles
- Work with business owners and IT resources to define report access and data-security requirements
- Protect sensitive or restricted information through approved security and governance practices
- Review access and security configurations as reports, users, responsibilities, and business requirements change
- Deployment, Refresh, and Production Support
- Configure and support gateways, data connections, credentials, scheduled refreshes, and related dependencies
- Use deployment pipelines and approved release processes to move Power BI content between development, testing, and production environments
- Monitor refresh activity, gateway availability, dataset performance, and production reporting issues
- Troubleshoot failed or incomplete refreshes, connectivity problems, credential issues, and data-source changes
- Coordinate testing and deployment activities with business owners, application teams, and Data & Analytics resources
- Support existing dashboards, reports, and semantic models through maintenance, issue resolution, and ongoing enhancements
- Communicate production issues, business impacts, workarounds, and resolution status to affected users
- Performance Monitoring and Optimization
- Monitor dashboard, report, semantic model, query, gateway, and refresh performance
- Review DAX measures, Power Query logic, relationships, visual interactions, and data volumes to identify performance issues
- Optimize semantic models and reports to improve response times, refresh duration, and overall usability
- Reduce unnecessary calculations, data duplication, model complexity, and report-level processing
- Work with data warehouse and source-system teams when performance issues originate outside Power BI
- Consider future data growth, user volume, refresh requirements, and reporting complexity when developing solutions
- Document material performance limitations, dependencies, or recommended improvements
- Data Governance and Documentation
- Use approved data warehouses, Microsoft Fabric, Snowflake, SQL, application sources, and certified enterprise datasets where applicable
- Follow established standards for naming, workspace organization, semantic modeling, security, deployment, and documentation
- Document data sources, transformations, relationships, measures, calculations, definitions, ownership, lineage, dependencies, refresh schedules, and support procedures
- Maintain documentation as reports, models, calculations, and data sources change
- Identify duplicate or conflicting reports, measures, KPIs, and business definitions and recommend a consistent approach
- Support the certification, endorsement, and governance of reusable semantic models and analytics content
- Work with Data & Analytics teams, application owners, and business users to resolve questions involving data ownership, definitions, quality, lineage, and availability
- Business Partnership and Requirements Gathering
- Lead or participate in requirements-gathering discussions with business owners and subject-matter experts
- Ask appropriate questions to clarify the business purpose, intended audience, required measures, level of detail, and expected use of an analytics solution
- Define KPIs and reporting requirements in terms that can be understood and validated by both business and technical teams
- Identify gaps, inconsistencies, and assumptions in reporting requirements before development begins
- Present prototypes and interim results to business users and incorporate feedback throughout development
- Explain technical limitations, data constraints, risks, and alternative approaches in clear business terms
- Support user acceptance testing, deployment, adoption, and ongoing improvement of analytics solutions
- Provide Accurate Project Effort Estimates
- Develop reasonable effort estimates for assigned analysis, design, development, testing, documentation, deployment, and support activities
- Identify data, access, technical, business, and resource dependencies that may affect delivery
- Manage assigned work and meet agreed project milestones and delivery commitments
- Communicate progress, issues, risks, scope changes, and dependencies in a timely manner
- Coordinate work with business owners, Data & Analytics teams, application owners, and other technical resources
- Follow approved project, development, testing, and change-management practices throughout the solution lifecycle
- Technology Evaluation and Continuous Improvement
- Maintain current knowledge of Power BI, Microsoft Fabric, Snowflake, Azure DevOps, APIs, embedded Power BI, custom visuals, and related analytics technologies
- Evaluate new Power BI and analytics capabilities for practical use in reporting, semantic modeling, deployment, governance, and self-service analytics
- Use AI-assisted or agentic development tools, where appropriate and approved, to support development, testing, documentation, troubleshooting, and productivity
- Identify opportunities to improve existing reports, reduce manual reporting, automate repeatable work, and expand the use of governed analytics
- Share technical knowledge, reusable approaches, lessons learned, and development practices with other team members
Requirements
- Not specified
- Experience in a manufacturing
- Experience in a distribution
- Experience in a inventory
- Experience in a sales
- Experience in a purchasing
- Experience in a aerospace
Nice to have: Microsoft Fabric, Snowflake, Azure DevOps, APIs, embedded Power BI, custom visuals, AI-assisted or agentic development tools
Skills
Benefits
- Medical (PPO High/Low or Health Savings Plan)
- Dental
- Vision
- Paid Time Off
- Life Insurance
- Short & Long-Term Disability
- Flexible Spending Accounts
- 9 Paid Company Holidays
- Employee Assistance & Wellness Programs
- Educational Assistance
More jobs nearby
Full description
AMI Metals, Inc.
Company details are for members
Sign up for a free job alert to see AMI Metals, Inc.'s profile, website and LinkedIn, and the same for every employer on Referso Jobs.