Data Engineer
Job Description
CAI is hiring a Data Engineer for a full-time remote position aligned to Eastern Standard Time. In this role, you will help build and refine enterprise reporting solutions, turn business needs into scalable data services, and provide technical guidance to support data quality and team effectiveness. If you value clear documentation, strong data integrity, and collaboration across teams, this position offers a solid foundation to grow your impact.
What You’ll Do
- Partner with business units to gather requirements, understand data needs, and deliver reporting solutions that support operational and strategic goals
- Develop, maintain, and optimize SSRS reports and Power BI dashboards for actionable business insights
- Write, troubleshoot, and optimize SQL queries for data extraction, transformation, and analysis
- Ensure data accuracy, consistency, and integrity across all reporting platforms
- Provide timely, insightful analysis for ad hoc data requests from business partners
- Document report logic, data definitions, and processes to support transparency and knowledge sharing
- Support data quality initiatives and contribute to continuous improvement of reporting processes
- Participate in code review sessions, script testing, error correction, and code modifications as needed
- Implement business rules using stored procedures, middleware, and other applicable technologies
- Maintain and regularly update technical documentation, data definitions, and reporting logic in the team wiki
- Assist in the development, maintenance, and operation of Azure DevOps pipelines and BI Support application lifecycle management processes
- Mentor and support team members through technical guidance and sharing best practices
- Collaborate with cross-functional teams to align with data standards and governance requirements
- Perform other duties as assigned
What You’ll Need
- 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
Compensation and Benefits
Pay range: $95,000-$105,000 per year.
- 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
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 Statement
CAI’s policy is not to discriminate against employees or applicants based on race, color, religion, sex, sexual orientation, gender identity, national origin, age, marital status, genetic information, disability, or protected veteran status. CAI also commits to affirmative action and bases employment decisions only on valid job requirements, including protections against harassment and retaliation.
Technologies You’ll Work With
- SQL Server 2016, SQL, SQL scripts
- SSRS, SSMS, SSIS
- Power BI
- Visual Studio 2016, C#, Microsoft .NET Framework 4.0
- Azure DevOps, source control tools
- Stored procedures, scripting, team wiki
- BI Support application lifecycle management
- Microsoft SQL Server operating systems
Physical Demands
- Ability to safely perform essential job functions consistent with ADA and other federal, state, and local standards
- Sedentary work, typically sitting or remaining stationary most of the time, with occasional movement to attend meetings and perform job-related tasks
- Ability to conduct repetitive computer tasks using a mouse, keyboard, and monitor