Software Engineer - Power BI and Analytics (Hybrid)

AMI Metals; Fort Worth (TX); On-site; USD 90,000 - 150,000; Full time

Benefits offered by this job

Medical (PPO High/Low or Health Saving

Dental

Vision

Paid Time Off

Life Insurance

Short & Long-Term Disability

Flexible Spending Accounts

9 Paid Company Holidays

Employee Assistance & Wellness

Educational Assistance

Job summary

AMI Metals, Inc. is seeking a Power BI & Analytics Engineer to join the Software Development team in Fort Worth, TX. You will design and deliver governed semantic models, dashboards, and self-service analytics using sources like Microsoft Fabric, Snowflake, and SQL data warehouses.

You will work with business owners to define KPIs, ensure accuracy, and provide reliable insights. The role emphasizes data governance, performance tuning, and end-to-end analytics delivery in an aerospace-grade

Qualifications

• Advanced experience with Power BI, DAX, Power Query, dimensional modeling, and SQL.

Responsibilities

• Develop Power BI dashboards, reports, semantic models, and analytics solutions.
• Define KPIs with stakeholders and translate requirements into secure, scalable models.
• Validate results and ensure data accuracy, security, and governance across enterprise sources.

Skills

Power BI

DAX

Power Query

SQL

Dimensional modeling

Data storytelling

Dashboard design

Requirements gathering

Tools

Microsoft Fabric

Snowflake

APIs

Job description

Location/Org Data : Logo

Job Summary

AMI Metals, Inc. (www.amimetals.com) is globally recognized as the industry leader in supplying aircraft quality raw material products to the aerospace industry. We are a wholly owned subsidiary of Reliance, Inc. (www.reliance.com) who is the largest metals service center company in North America and recognized as a Fortune’s World’s Most Admired Companies!

WHY WORK FOR AMI?We value our employees and consider them to be our most important asset! We hire people who seek a professional, team-oriented environment which values collaboration and knowledge sharing. AMI is committed to employee safety, quality/continuous improvements, productivity and growth opportunities! Check out our reviews on and Glassdoor.

EMPLOYEE BENEFITS:

We offer our employees and their dependents with a comprehensive benefits package which include:

• 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

Physical Requirements

Stand or Sit(Stationary position), Walk(Move, Traverse), Use hand/fingers to handle or feel (Operate, Activate, Use, Prepare, Inspect, Place, Detect, Position), Talk/hear(Communicate, Detect, Converse with, Discern, Convey, Express oneself, Exchange information), See (Detect, Determine, Perceive, Identify, Recognize, Judge, Observe, Inspect, Estimate, Assess), Reaching, Repetitive Motion

Function in the Job

Sedentary Work- Exerting up to 10 pounds of force occasionally, and/or a negligible amount of force frequently or constantly to lift, carry, push, pull or otherwise move objects, including the human body. Sedentary work involves sitting most of the time. Jobs are sedentary if walking and standing are required only occasionally, and all other sedentary criteria are met.

Job Function

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. The individual will work with business owners to define KPIs, understand reporting requirements, validate results, and deliver clear and reliable business insights. The role will support the development, testing, deployment, performance tuning, maintenance, and ongoing operation of Power BI solutions using approved enterprise data sources, including Microsoft Fabric, Snowflake, SQL, data warehouses, and application systems. The Power BI & Analytics Engineer must also ensure that calculations, data models, security, refresh processes, and reporting outputs are accurate, documented, supportable, and aligned with certified enterprise data definitions.

ESSENTIAL FUNCTIONS:

Analytics Solution Design – Able to identify, analyze, and translate business reporting and analytics needs into secure, scalable, and maintainable Power BI solutions.

• 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.
• Identify opportunities to reuse existing semantic models, certified data, business definitions, and reporting components.

Power BI Development – Able to develop, test, troubleshoot, and maintain Power BI solutions that provide accurate and actionable information.

• 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 – Able to present complex business information in a clear, useful, and visually effective manner.

• 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 – Able to prepare, model, and organize data for reporting and analytical use.

• 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 – Ensures dashboards, semantic models, calculations, and reporting results accurately reflect approved data sources and business definitions.

• 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 – Able to implement and maintain appropriate access and data-security controls for Power BI solutions.

• 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 – Able to deploy, monitor, maintain, and support Power BI solutions throughout their lifecycle.

• 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 – Able to analyze and improve the performance, scalability, and reliability of Power BI solutions.

• 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 – Able to develop analytics solutions that use approved data, established definitions, and supportable 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 – Able to work directly with business users to develop analytics solutions that address practical operational and decision-making needs.

• 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.

Required Skills

Required

• Advanced experience with Power BI, DAX, Power Query, dimensional modeling, and SQL.
• Strong dashboard design, requirements gathering, and data storytelling skills.
• Experience with Power BI gateways, workspaces, security, deployment, refresh management, and performance optimization.
• Ability to validate and reconcile reporting results and clearly explain calculations, data sources, and results to business users.

Preferred

• Experience with Microsoft Fabric, Snowflake, Azure DevOps, APIs, embedded Power BI, and custom visuals.
• Experience using AI‑assisted or agentic development tools such as GitHub Copilot, Claude Code, Codex, AWS Kiro, Snowflake Coco, or similar tools.

Experience developing analytics solutions supporting manufacturing, distribution, inventory, sales, purchasing, or aerospace operations.

Problem Solving - Ability to problem solve through problem identification (what is the problem), solution assessment (what can be done), problem documentation (document for future) and problem response (implementing a solution).

Able to:

Frame problems before trying to solve them

Break down medium to high complexity problems and identify all of their components

Provide insight into the root‑causes of problems

Seek advice from those who have solved similar problems

Anticipate problems and is proactive in addressing them

Follow up to ensure that the problem has been resolved

Ask perceptive questions to seek optimal solutions

Explore various sources for answers, and think "outside the box" to find options

Be open to others' ideas to help develop solutions

Generate a range of solutions and courses of action with benefits, costs, and risks associated with each

Evaluate the chosen course of action to determine its worth and impacts

Able to:

Gather data and others' input when making decisions

Escalate decisions when appropriate

Weigh pros and cons of each option before making a decision and moving forward

Balance analysis, insight, experience, and perspective when making decisions

Explain the rationale for a decision

Find solutions that are acceptable to diverse groups with conflicting interests and needs

Willing to make decisions in difficult situations in a timely manner

Consider lessons learned from experience, differing needs, and the impact of the decision on others

Customer Service - Ability to develop and maintain strong relationships with others by listening, understanding and responding to their needs.

Able to:

Provide service to internal and external customers to satisfy their needs and expectations

Listen to concerns and resolve reported issues effectively and promptly

Ensure and comply to customer response timeline (SLAs) based on the severity of reported issues including documenting concise and accurate status information in the ServiceNow ticketing system

Deliver high quality products and services

Commit to continuous improvement

Develop to meet functional design/requirements

Anticipate customer’s needs and moves to effectively address issues

Establish proactive relationship with customers

Elicit feedback from customers

Deliver high quality solutions that meet the organization’s needs

Company Business Knowledge - Understands the company, its products and the business processes.

Able to:

Develop understanding of common business processes within Reliance

Apply broad (two or more areas) Reliance business knowledge to technology solutions

Accountability - Holds self-accountable for measurable high-quality, timely, and cost-effective results.

Able to:

Proactively collaborate between own functional area and areas below or above in the project stream as needed

Set well-defined and realistic personal goals

Comply with established policies and procedures

Accept responsibility for mistakes

Display a high level of initiative, effort, and commitment towards completing assignments

Minimize re-work

Seek out learning opportunities

Identify training needs and take action to obtain knowledge

Anticipate and adjust for problems and roadblocks

Be enthusiastic for the things he/she sees as challenging

Be proactive throughout work assignments /projects

Persistently push self and others for results

Help others learn

Make good decisions on behalf of the company (profitability, compliance)

Provide consistency between projects

Communication - Communicates effectively across all levels to support departmental and organizational objectives.

Able to:

Establish rapport with co-workers easily

Clearly express information taking into account audience and nature of the information (for example, non-technical, sensitive, and controversial)

Ask questions and summarize what was heard to prevent miscommunication

Present information in a concise and focused manner

Listen to others

Communicate written information (for example, facts, ideas, or messages) in a succinct and organized manner

Produce written information, which may include technical material that is appropriate for the intended audience

Share ideas and perspectives and encourage others to do the same

Inform others involved in a project of new developments

Ensure written messages have the desired effect on the target audience

Building Collaborative Relationships - Develops, maintains, and strengthens partnerships with others inside and/or outside the organization.

Able to:

Establish rapport with co-workers easily

Encourage and facilitate cooperation, pride, trust and group identity

Foster commitment and team spirit

Work with others to achieve goals

Listen and respond constructively to other team members' ideas

Offer support for others' ideas and proposals

Be open with other team members about his/her concerns

Share his/her expertise with others

Acknowledge team members for their contributions

Provide assistance to others when they need it

Work for solutions that all team members can support

Effectively persuades and influences team members to achieve goals

Effectively collaborate with geographically distributed teams

Leadership – Displays effort and commitment in carrying out the department’s goals and objectives.

Able to:

Act in a proactive and achievement-oriented manner

Treat co-workers in a fair and equitable manner

Empower others by sharing information

Actively listen and clarify information as needed

Foster an atmosphere of open communication

Behave in a tactful, compassionate, and sensitive manner

Consider and respond appropriately to the needs, feelings, and capabilities of different people in different situations

EEO/Disabled/Veterans

AMI Metals, Inc. provides equal employment opportunities to applicants and employees without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, protected veteran status, or disability.