Data Engineer

CAI, Inc.
Montpelier, VT, United States
1 day ago
Apply on dejobs.org
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Experienced
Experience required
4 years minimum
Compensation
$95,000 - $105,000
Working hours
Regular working hours
Job source

Tech stack

.NET Framework Amazon Web Services Business Analytics Applications Application Lifecycle Management Microsoft Azure C Sharp (Programming Language) Code Review Databases Data Governance Data Mining Middleware R (Programming Language)
+17 more
Python (Programming Language) Microsoft Data Access Components Microsoft Visual Studio Microsoft SQL Server Power BI Azure DevOps Pipelines Software Engineering SQL Stored Procedures SQL Databases SQL Server Reporting Services SQL Server Integration Services Scripting Information Technology Data Analytics Tools for Reporting SQL Server Management Studio (SSMS) Software Version Control

Job description

As the Data Engineer, you will be responsible for developing and maintaining enterprise reporting solutions, supporting business operations through scalable data solutions, and providing technical leadership and mentorship to team members., We are seeking a Data Engineer to join our client’s team in a Full-Time and Remote role. This position will require this person to work Eastern Standard Time. This position is responsible for developing and maintaining enterprise reporting solutions, supporting business operations through scalable data solutions, and providing technical leadership and mentorship to team members.

What You’ll Do

  • Collaborate with business units to gather requirements, understand data needs, and translate them into effective reporting solutions that support operational and strategic goals

  • Develop, maintain, and optimize SSRS reports and Power BI dashboards to provide 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

  • Support 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

  • Participate in data quality initiatives and contribute to continuous improvement of reporting processes

  • Participate in code review sessions, script testing, error correction, and code modifications as required

  • Implement business rules through stored procedures, middleware, and other technologies

  • Maintain and regularly update technical documentation, data definitions, and reporting logic within 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 ensure alignment with data standards and governance requirements

  • Perform other duties as assigned

Requirements

  • 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

  • Knowledge of Microsoft SSRS reporting software

  • 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 within 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

Preferred:

  • Recent experience with SQL database management and development

  • Experience with Power BI, analytical tools, R, Python, Visual Studio, and SSRS

  • Microsoft data systems certifications

  • CSTP, ISTQB, ASTQB, MTA, MCSA, MCSD, MCSE, ITIL v3, Power BI, AWS, Azure, INFORMS, IIBA, or equivalent certifications

Physical Demands

  • Ability to safely and successfully perform the essential job functions consistent with the ADA and other federal, state, and local standards

  • Sedentary work that involves sitting or remaining stationary most of the time with occasional movement to attend meetings and perform job-related tasks

  • Ability to conduct repetitive tasks on a computer, utilizing a mouse, keyboard, and monitor

Benefits & conditions

$95,000-$105,000

The pay range for this position is listed above. Exact compensation may vary based on several factors, including location, experience, and education. Benefit packages include medical, dental, and vision insurance, as well as 401k retirement account access. Employees in this role receive paid time off and may also be entitled to paid sick leave and/or other paid time off as provided by applicable law.

About the company

CAI is a global services firm with over 9,000 associates worldwide and a yearly revenue of $1.3 billion+. We have over 40 years of excellence in uniting talent and technology to power the possible for our clients, colleagues, and communities. As a privately held company, we have the freedom and focus to do what is right-whatever it takes. Our tailor-made solutions create lasting results across the public and commercial sectors, and we are trailblazers in bringing neurodiversity to the enterprise.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on dejobs.org
Prepare application

Good distractions

Loading talks and stories from around this role…