Software Engineer - Power BI and Analytics (Hybrid)

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

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.

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.

Provide Accurate Project Effort Estimates – Able to estimate, manage, and complete assigned analytics development and support activities.

• 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 – Able to evaluate emerging analytics and development capabilities and identify practical uses within the organization.

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

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

Decision making - Makes sound, well-informed, and objective decisions; perceives the impact and implications of decisions; commits to action, even in uncertain situations, to accomplish organizational goals.

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.