Reporting Application Developer

Power BI & Reporting Development

• Design develop and maintain interactive Power BI dashboards and data models for business and executive audiences.

• Build DAX measures calculated columns and KPI logic; implement Row-Level Security (RLS) and report governance policies.

• Publish and manage reports via Power BI Service including workspace management scheduled refresh and deployment pipelines.

• Develop SSRS paginated reports for operational or regulatory use cases requiring pixel-perfect formatting.

Data Platform Awareness & SQL Development

• Write and optimize T-SQL queries against Fabric Warehouse and Lakehouse SQL endpoints including CTEs window functions and views to support reporting layers.

• Understand and navigate a Medallion architecture (Bronze/Silver/Gold) to identify the correct Gold-layer datasets for Power BI consumption collaborating with the Data Engineering team where upstream changes are needed.

• Apply working knowledge of star and snowflake schema design to interpret existing data models and raise dimensional modeling concerns with the data engineering team.

• Conduct data profiling and quality checks on Gold-layer data surfacing issues to the data engineering team for remediation upstream.

Stakeholder Collaboration & Requirements Gathering

• Partner with business stakeholders across Finance Operations HR and IT to gather document and prioritize reporting requirements.

• Translate business requirements into functional technical specifications data models and report designs.

• Serve as the subject-matter expert on report capabilities data availability and BI best practices across the team.

Operations Support & Continuous Improvement

• Provide Level 2/3 support for reporting applications investigating and resolving data discrepancies and report failures.

• Monitor Fabric data refreshes and report pipelines proactively addressing failures and surfacing upstream data issues.

• Document report logic SQL views and data flows; stay current with Power BI and Microsoft Fabric feature releases.

• Bachelors degree in Computer Science Information Technology or a related field.

• 4 to 6 years of hands-on experience in a BI/reporting developer role.

• Advanced proficiency in Power BI Desktop and Power BI Service including DAX and Power Query (M).

• Strong T-SQL skills: complex joins CTEs window functions and stored procedures.

• Solid experience designing and implementing SSRS reports (tabular matrix parameterized drilldown).

• Familiarity with Medallion architecture (Bronze/Silver/Gold) and star/snowflake dimensional modeling sufficient to work confidently with Gold-layer datasets and liaise with Data Engineering.

• Strong analytical communication and problem-solving skills; able to work independently and manage competing priorities.

• Hands-on experience with Microsoft Fabric (Lakehouse Warehouse Dataflows Gen2 or Fabric Notebooks) advantageous but not required.

• Exposure to additional BI platforms (Tableau Qlik Looker) or Azure data services (ADF Synapse).

• Knowledge of Python or PowerShell for automation and scripting.

• Experience with Git/Azure DevOps for source control and CI/CD of BI artifacts.

Black Box is a leading technology solutions provider. Our mission is to accelerate our customers business by valuing relationships with our team members clients and stakeholders. By continuously growing our knowledge we remain relevant in the market and are in a superior position to help customers design deploy and manage their IT infrastructure. Through our values such as innovation ownership transparency respect and open-mindedness we deliver high-value products and services through our global presence and 2500 team members in 24 countries and growing. Black Box is a wholly-owned subsidiary of AGC Networks.

Black Box is an equal opportunity employer. Black Box does not discriminate against individuals on the basis of race color marital status sex sexual orientation gender identity religion national origin age disability veteran status genetic information or any other protected status and endorses those policies and practices which seek to recruit hire train and promote the most qualified persons into available jobs.