BI Developer

Job Title:

• BI Developer
• Location/Work Structure:

• On-site, Columbus
• Compensation:

• $70,000–$100,000 annually
• Who We Are:

• Vernovis is a Total Talent Solutions company that specializes in Technology, Cybersecurity, Finance & Accounting functions. At Vernovis, we help these professionals achieve their career goals, matching them with innovative projects and dynamic direct hire opportunities in Ohio and across the Midwest.
• Client Overview:

• Vernovis is partnering with a client to find a BI Developer to join its Business Intelligence team. This individual will be responsible for building and maintaining reports, dashboards, and semantic models that drive decision-making across the company. The role is split roughly evenly between report development and analytics engineering.
• The company is modernizing its reporting platform on Microsoft Fabric, moving from a legacy SSRS and large-import-model estate to a governed, Direct Lake semantic layer fed by its medallion data warehouse. The BI Developer will be a key builder in that modernization effort.

What Experience You’ll Have:

• Supported report conversions from legacy import models and SSRS to the Direct Lake/MI Cube architecture, ensuring converted reports stay accurate and consistent.
• Strong experience with both Power BI report development and analytics engineering.
• Experience building and maintaining Power BI semantic models, including measures, relationships, and role-level security.
• Experience writing and optimizing DAX for complex business logic, including time intelligence, evaluation context, financial calculations, and conditional aggregations.
• Experience maintaining semantic models in TMDL format with version control through Git and deployment pipelines.
• Ability to work directly with business stakeholders to gather, clarify, and document reporting requirements.
• What You’ll Do:
• Support conversion of reports from legacy import models and SSRS to the Direct Lake/MI Cube architecture, ensuring converted reports stay accurate and consistent.
• Design, build, and maintain Power BI interactive reports and dashboards for stakeholders across finance, sales, and operations.
• Translate business requirements into clear, accurate, and performant report layouts and visualizations.
• Validate report outputs against source data and business expectations before production deployment; participate in review cycles with stakeholders.
• Develop Power BI paginated reports where that format is the right fit; maintain a small legacy SSRS estate as a minor ongoing task during the transition.
• Build and maintain Power BI semantic models, including measures, relationships, and role-level security.
• Write and optimize DAX for complex business logic, including time intelligence, evaluation context, financial calculations, and conditional aggregations.
• Maintain semantic models in TMDL format with version control through Git and deployment pipelines.
• Ensure models are structured for reuse across reports and aligned to a single source of truth, centralizing business logic rather than burying it in individual reports.
• Work directly with business stakeholders to gather, clarify, and document reporting requirements, including whether a report is still needed and how the underlying process now works in current systems.
• What Experience Is Nice to Have:
• Experience supporting the conversion of legacy import models and SSRS reports to a Direct Lake/MI Cube architecture.
• Experience developing Power BI paginated reports and maintaining legacy SSRS reports.
• A practical orientation toward using AI to work efficiently and solve business problems.

By applying for this job, you agree to receive calls, AI-generated calls, text messages, or emails from and its affiliates, and contracted partners. Frequency varies for text messages. Message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You can reply STOP to cancel and HELP for help. You can access our privacy policy at https://vernovis.com/privacy-policy-2/.