DataJobs.io
← Back to all jobs

Job Description

Full-time, remote (Eastern Standard Time) role with CAI to build and improve enterprise reporting that helps teams make better operational and strategic decisions. If you enjoy turning business requirements into reliable, scalable data solutions, this position brings a mix of reporting development, SQL work, and technical collaboration.

What you’ll do

  • Partner with business units to gather requirements, understand data needs, and translate them into effective reporting solutions aligned to operational and strategic goals
  • Develop, maintain, and optimize SSRS reports and Power BI dashboards to deliver actionable insights
  • Write, troubleshoot, and optimize SQL queries for data extraction, transformation, and analysis
  • Ensure data accuracy, consistency, and integrity across reporting platforms
  • Handle ad hoc data requests and provide timely, insightful analysis to business partners
  • Document report logic, data definitions, and processes to support transparency and knowledge sharing
  • Contribute to data quality initiatives and continuous improvement of reporting processes
  • Participate in code review, script testing, error correction, and code modifications as needed
  • Implement business rules using stored procedures, middleware, and other technologies
  • Maintain technical documentation, data definitions, and reporting logic in the team wiki
  • Support development, maintenance, and operation of Azure DevOps pipelines and BI Support application lifecycle management processes
  • Mentor team members through technical guidance and sharing best practices
  • Collaborate cross-functionally to align with data standards and governance requirements
  • Perform other duties as assigned

What we’re looking for

  • Associate degree and 4 years of experience in Information Technology/MIS, Mathematics, Statistics, Data Analytics, Engineering Sciences, Business, Healthcare Administration, Human Services, healthcare claims and reporting environments, or application development and support
  • Experience with SQL Server 2016 or higher
  • Experience writing SQL scripts and developing stored procedures
  • Experience with SSRS, SSMS, SSIS, Power BI, Visual Studio 2016 (or higher), Azure DevOps, and source control tools
  • Experience with C# and Microsoft .NET Framework 4.0 (or higher)
  • Knowledge of Microsoft SQL Server operating systems
  • Knowledge of indexes, index management, and database statistics
  • Knowledge of implementing operational automation through scripting
  • Knowledge of Microsoft Power BI (or comparable analytics software) and Microsoft SSRS reporting
  • Ability to translate and communicate complex technical concepts to both technical and non-technical audiences
  • Ability to prepare implementation plans across multiple platforms
  • Strong customer service, communication, analytical, problem-solving, and organizational skills
  • Strong attention to detail, with the ability to prioritize tasks and manage complex technical procedures
  • Ability to work independently and collaboratively in a team environment
  • Certification required for candidates qualifying through a 2-year degree pathway
  • Equivalent combinations of education and experience may be considered
  • Valid active driver’s license maintained throughout employment

Benefits

  • Medical, dental, and vision insurance
  • 401k retirement account access
  • Paid time off
  • Paid sick leave and/or other paid time off as provided by applicable law

Pay range

$95,000 to $105,000 per year.

Reasonable accommodation

If you require a reasonable accommodation in completing this application, interviewing, completing any pre-employment testing, or otherwise participating in the employment selection process, direct inquiries to [email protected] or (888) 824-8111.

EEO

CAI’s policy is not to discriminate against any employee or applicant due to protected characteristics and to provide affirmative action in employment decisions. CAI prohibits harassment and retaliation under applicable federal, state, and local EEO laws.

Similar Jobs