BI Developer
Posted Updated
Description
Key Responsibilities
- Assess the existing SAP BusinessObjects universes, reports, and security models. Identify which reports to convert, consolidate, or retire, and plan their move to Power BI.
- Design Power BI data models and semantic layers on Teradata and the cloud data platform to replace the BusinessObjects universes. Work with the DBA and data modelers to shape a physical design that fits the customer’s reporting needs.
- Rebuild BusinessObjects reports as Power BI reports and dashboards, keeping the business logic and results intact.
- Tune Power BI performance, including DAX optimization, choosing between Import and DirectQuery, and writing efficient queries against Teradata and the cloud data platform.
- Build and maintain reporting solutions on a cloud data platform, including the data pipelines and data stores that feed Power BI.
- Publish and manage content in the Power BI Service, including workspaces, gateways, scheduled refreshes, and deployment pipelines.
- Build generative AI solutions for reporting and analytics, such as natural language querying. Use Gen AI tools to speed up the conversion by analyzing legacy report logic and generating documentation.
- Analyze project requirements and write detailed specifications for new and existing data warehouse reports.
- Build and validate test data and scenarios using deep knowledge of the agency’s healthcare business rules, then run tests to confirm the reporting logic produces the right results.
- Validate converted reports against the BusinessObjects originals and resolve any differences before cutover.
- Help users through the transition with training, guides, and support, so reporting continues without interruption.
- Meet with users to clarify problems and shape a development plan. Gather and analyze the facts, define the problem, and recommend solutions and alternatives.
- Work with developers and the DBA to create and maintain design standards and document the converted reports and data models.
- Mentor other developers on Power BI and the conversion approach.
- Communicate clearly, in meetings and in writing, with everyone involved in the work: developers, analysts, your manager, leadership, report users, operations staff, other state agencies, and partners.
Required qualifications
- Bachelor’s degree in technology or computer science
- Hands on Power BI development, including data modeling, DAX, Power Query, and row-level security
- Experience converting BusinessObjects (or other legacy BI) reports to Power BI
- 8+ years of SQL development, including 4+ years of performance tuning
- 2+ years with Teradata 14 or later
- 2+ years of cloud data platform experience, including building data pipelines and working with cloud data warehouses
- 2+ years on data warehouse projects
- Experience with healthcare data, ideally state Medicaid or Medicare
- Experience developing generative AI solutions
Preferred qualifications
- 2+ years leading a team or module
- Experience with Tableau, BI Query or other reporting tools
- Microsoft certification, such as Power BI Data Analyst or a certification in a cloud data platform
- Experience moving on-premises data or reporting workloads to the cloud
- Strong written and verbal communication, client facing, and collaboration skills
Skills
Sign in to read and join the discussion.