Cotiviti - South Jordan, UT

posted 3 months ago

Full-time - Mid Level
Remote - South Jordan, UT
Professional, Scientific, and Technical Services

About the position

The Business Intelligence Developer - Power BI at Cotiviti, Inc. plays a crucial role in enhancing the company's data reporting capabilities. This position involves collaborating with various team members and operational departments to develop both internal and external reporting tools. The developer will gather and analyze requirements using industry best practices, ensuring that the reporting tools meet the needs of the business. The role requires extensive work in both ad-hoc and standard reporting packages, focusing on creating reports and dashboards that can handle large volumes of data efficiently. In this position, the developer will design, develop, and maintain Power BI reports and dashboards tailored to support the business intelligence needs of the organization. They will transform raw data into actionable insights through interactive and user-friendly reports, integrating data from various sources into Power BI using SQL queries and Dataflows. The developer will manage data connections, data models, and transformations within the Power BI environment, ensuring data integrity by collaborating with data owners and stakeholders to understand their requirements. The role also involves writing and optimizing SQL queries to extract and manipulate data for reporting purposes, utilizing Power BI Dataflows to prepare and transform data for analysis. The developer will maintain and troubleshoot dataflows to ensure continuous data refresh and availability, supporting senior team members in implementing data governance practices and defining security, permissions, and data access controls within Power BI. Additionally, they will help create visually compelling reports that provide valuable insights to decision-makers and collaborate with cross-functional teams to understand business outcomes and solution requirements. The Business Intelligence Developer will also assist in optimizing processes to improve efficiency and deliver high-quality solutions, support performance tuning of semantic models and reports through DAX and Power Query M code optimization, and implement performant data modeling solutions using various Power BI storage modes. Monitoring platform utilization and assisting in capacity management and growth planning are also key responsibilities of this role. The developer will complete all responsibilities as outlined in the annual performance review and/or goal setting, as well as any special projects and other duties as assigned. The position requires the ability to perform duties with or without reasonable accommodation.

Responsibilities

  • Design, develop, and maintain Power BI reports and dashboards to support business intelligence needs.
  • Transform raw data into actionable insights through interactive and user-friendly reports.
  • Integrate data from various sources into Power BI using SQL queries and Dataflows to provide comprehensive insights.
  • Manage data connections, data models, and transformations within the Power BI environment.
  • Collaborate with data owners and stakeholders to understand data requirements and ensure data integrity.
  • Write and optimize SQL queries to extract and manipulate data for reporting purposes.
  • Utilize Power BI Dataflows to prepare and transform data for analysis.
  • Maintain and troubleshoot dataflows to ensure continuous data refresh and availability.
  • Support senior team members in implementing data governance practices and defining security, permissions, and data access controls within Power BI.
  • Help create visually compelling and insightful reports that provide valuable insights to decision-makers.
  • Collaborate with cross-functional teams, including data analysts, business stakeholders, and IT professionals, to understand business outcomes and solution requirements.
  • Assist in optimizing processes to improve efficiency and deliver high-quality solutions.
  • Support performance tuning of semantic models and reports through DAX and Power Query M code optimization.
  • Implement performant data modeling solutions using all types of Power BI storage modes.
  • Monitor platform utilization and assist in capacity management and growth planning.
  • Complete all responsibilities as outlined in the annual performance review and/or goal setting.
  • Complete all special projects and other duties as assigned.

Requirements

  • Bachelor's degree in computer science, information technology, engineering or equivalent.
  • 5+ years of working experience in both Oracle and SQL Database environments.
  • 5+ years of experience developing reporting products/solutions using Microsoft Power BI, MS SQL Server (currently 2016 or above), SQL Server Integration Services (SSIS), and SQL Server Reporting Services (SSRS).
  • 4+ years of experience building visually appealing reports in Power BI (or other BI reporting tools).
  • 3+ years of experience in working with the Microsoft Fabric platform outside of Power BI.
  • Experience working with Power Apps and Power Automate.
  • Advanced knowledge and experience of Microsoft Fabric, AI, Copilot, and model deployment using GitHub.
  • Hands-on experience in Oracle and SQL and query optimization, working in RDBMS and Data Warehousing (ERD and Dimensional modeling).
  • Experience modeling data in Power BI Semantic Modeling.
  • Experience working with APIs using Python.
  • Experience with Scrum framework and Agile methodology.
  • Experience with CICD frameworks and common DevOps practices.
  • Experience working in an onsite-offshore model.
  • Experience in working with other BI solutions such as Tableau, MicroStrategy, and Business Objects.

Nice-to-haves

  • Experience with data visualization best practices.
  • Familiarity with cloud-based data solutions.
  • Knowledge of machine learning concepts and applications in BI.

Benefits

  • Health insurance coverage.
  • 401k retirement savings plan.
  • Paid holidays and vacation time.
  • Professional development opportunities.
  • Flexible work hours.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service