Cotiviti - Remote, OR

posted 3 months ago

Full-time - Mid Level
Remote, OR
Professional, Scientific, and Technical Services

About the position

The Business Intelligence Developer plays a crucial role in collaborating with various team members and operational departments to develop both internal and external reporting tools. This position involves gathering and analyzing requirements using industry best practices, and the developer will work extensively with both ad-hoc and standard reporting packages. The primary focus will be on creating reports and dashboards that can handle large volumes of data, ensuring that insights are actionable and user-friendly. In this role, 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 reports, integrating data from various sources 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 position also requires writing and optimizing SQL queries for data extraction and manipulation, utilizing Power BI Dataflows for data preparation, and maintaining dataflows to ensure continuous data refresh and availability. The developer will support senior team members in implementing data governance practices, defining security, permissions, and data access controls within Power BI. Additionally, they will assist in creating visually compelling reports that provide valuable insights to decision-makers and collaborate with cross-functional teams to understand business outcomes and solution requirements. Performance tuning of semantic models and reports through DAX and Power Query M code optimization will also be part of their responsibilities, along with monitoring platform utilization and assisting in capacity management and growth planning.

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 & 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 advanced analytics and machine learning techniques.
  • Familiarity with cloud-based data solutions and architectures.
  • Knowledge of data visualization best practices and principles.
  • Experience in training or mentoring junior team members.

Benefits

  • Medical insurance coverage
  • Dental insurance coverage
  • Vision insurance coverage
  • Disability insurance coverage
  • Life insurance coverage
  • 401(k) savings plans
  • Paid family leave
  • 9 paid holidays per year
  • 17-27 days of Paid Time Off (PTO) per year, depending on specific level and length of service with Cotiviti.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service