Software Engineer - Power BI and Analytics (Hybrid)

reliance•Fort Worth, TX

6d•Hybrid

About The Position

AMI Metals, Inc., a wholly owned subsidiary of Reliance, Inc., is hiring a Software Engineer for Power BI and analytics. The role is an integral member of the Software Development team and is responsible for developing governed semantic models, dashboards, reports, and self-service analytics solutions. The engineer works with business owners and subject-matter experts to define KPIs, understand reporting requirements, validate results, and deliver clear, reliable business insights. The position supports 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. It ensures that calculations, data models, security, refresh processes, and reporting outputs are accurate, documented, supportable, and aligned with certified enterprise data definitions. The role involves analytics solution design, Power BI development, dashboard design and data storytelling, data modeling and transformation, data validation and reconciliation, security and access management, deployment and production support, performance optimization, data governance and documentation, business partnership, project estimation, and evaluation of analytics technologies. It also supports user acceptance testing, adoption, ongoing improvements, and collaboration with business users, Data & Analytics teams, application owners, and other technical resources. AMI describes its workplace as professional and team-oriented, with an emphasis on collaboration, knowledge sharing, employee safety, quality and continuous improvement, productivity, and growth opportunities. The position is listed as hybrid. The role has sedentary physical demands and involves sitting most of the time, with occasional standing and walking and other listed physical activities.

Requirements

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.
Ability to frame and break down complex problems, investigate root causes, assess solution options and trade-offs, document problems, and follow through on resolution.
Sound, well-informed decision-making, including gathering input, weighing options, escalating decisions when appropriate, and explaining decision rationale.
Strong customer-service skills, including listening, responding promptly to concerns, meeting applicable service timelines, and delivering quality solutions.
Ability to develop an understanding of company business processes and apply business knowledge to technology solutions.
Accountability for high-quality, timely, and cost-effective results; initiative, adherence to policies and procedures, continuous learning, and follow-through.
Effective written and verbal communication across technical and nontechnical audiences and organizational levels.
Ability to build collaborative relationships, work effectively with others, share expertise, and collaborate with geographically distributed teams.
Leadership qualities including proactive contribution, information sharing, open communication, fairness, and responsiveness to others' needs.

Nice To Haves

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 for manufacturing, distribution, inventory, sales, purchasing, or aerospace operations.

Responsibilities

Work with business owners and subject-matter experts to understand business processes, reporting needs, data requirements, and expected outcomes.
Translate business requirements into dashboards, reports, governed semantic models, KPIs, and self-service analytics solutions.
Design dimensional data models, relationships, hierarchies, measures, calculated columns, and business logic.
Evaluate enterprise data sources and reuse existing semantic models, certified data, definitions, and reporting components where appropriate.
Develop, test, troubleshoot, and maintain Power BI dashboards, reports, semantic models, scorecards, executive analytics, and reusable reporting components.
Develop and maintain DAX measures, calculated columns, Power Query transformations, hierarchies, filters, bookmarks, and drill-through experiences.
Connect Power BI solutions to approved SQL databases, data warehouses, Microsoft Fabric, Snowflake, APIs, application systems, and other enterprise data sources.
Design usable, consistent dashboards and reports that communicate performance, trends, exceptions, risks, and opportunities to operational users, managers, and executives.
Prepare, cleanse, transform, combine, model, and organize data for reporting and analytical use; identify and address data-quality issues.
Develop and document test scenarios; validate models, transformations, calculations, filters, security, and reporting results against approved sources and business definitions.
Investigate and resolve discrepancies between analytics results and source or operational systems, and explain calculations, assumptions, sources, and reconciliation results to users.
Configure and maintain row-level security and other access controls; support workspaces, applications, audiences, permissions, and content distribution.
Configure and support gateways, data connections, credentials, scheduled refreshes, and related dependencies.
Deploy content through approved release processes and deployment pipelines across development, testing, and production environments.
Monitor refresh activity, gateway availability, dataset performance, and production reporting issues; troubleshoot failures and communicate impacts and resolution status.
Monitor and optimize dashboard, report, semantic model, query, gateway, and refresh performance; document material limitations, dependencies, and recommended improvements.
Follow standards for naming, workspace organization, semantic modeling, security, deployment, and documentation; maintain documentation of data sources, transformations, calculations, lineage, dependencies, refresh schedules, and support procedures.
Identify duplicate or conflicting reports, measures, KPIs, and business definitions, and recommend consistent approaches; support certification and governance of reusable analytics content.
Lead or participate in requirements discussions, clarify business purpose and reporting needs, present prototypes, incorporate feedback, and support user acceptance testing, deployment, adoption, and ongoing improvement.
Estimate assigned analysis, design, development, testing, documentation, deployment, and support work; identify dependencies, manage assignments, meet milestones, and communicate progress, risks, and scope changes.
Coordinate work with business owners, Data & Analytics teams, application owners, and other technical resources, following approved project, development, testing, and change-management practices.
Maintain knowledge of relevant analytics technologies and evaluate capabilities for practical use; identify opportunities to improve reporting, automate work, and expand governed analytics.
Use AI-assisted or agentic development tools when appropriate and approved, and share technical knowledge, reusable approaches, lessons learned, and development practices with team members.
Provide internal and external customer service, respond to reported issues within applicable timelines, and document status information in the ServiceNow ticketing system.
Collaborate across teams, support colleagues, share expertise, and contribute to departmental and organizational goals.