Capio Group is looking for a Senior Data Engineer!

Full-time employee - Sacramento

About Us:

Since 2010, we have been working with some of the largest government agencies in California, helping them to solve their greatest challenges. We are a small firm dedicated to big ideas and enjoy the rewards that come from hard work and commitment to our client base. We offer the salary and benefits of the bigger companies with the added bonus of a flexible workplace and a great work-life balance. 

Scope of Work:

The Senior Data Engineer will work as part of a team to provide Data Cleanup & Migration Services for the client’s legacy system .The Engineer should have knowledge and experience in data cleanup, and migration services consisting of data profiling, data cleansing, data standardization, and data transformation to assist the client in successfully extracting data from the legacy system for data migration into the target database.
Tasks including but not limited to:

• Data Integration Plan and Schedule
• Data Profiling, Standardization and Cleansing
• Data Transformation
• Data Load
• Post-Implementation / Go-Live Data Quality Reporting
• Knowledge Transfer and Lessons Learned
• Unanticipated Tasks

Mandatory Experience:

1. Within the last 10 years, must have a minimum of four (4) years of relevant experience in authoring and monitoring data pipelines.
2. Must possess bachelor’s or advanced degree (master’s or PhD) in computer science, engineering, information systems, math, or technology-related field. Additional qualifying experience may be substituted for the required education on a year-for-year basis. Successful completion of a data engineering bootcamp plus an additional year of experience may be substituted for the degree requirement.
3. Within the last 10 years, at least five (5) years of experience on projects performing data migration duties with at least three (3) years of experience serving in a lead role designing solutions for projects converting records from a legacy system of similar database size, over fifty (50) gigabytes (GB) like the legacy NAP database in Oracle, into one consolidated database not limited to data profiling, cleansing, transforming, and loading records.
4. Within the last 10 years, at least five (5) years of experience developing and executing data conversion and transformation effort strategies, including establishing rules, dependencies, and acceptance criteria for large-scale transformation efforts.
5. Within the last 10 years, at least five (5) years of experience with data conversion, data quality and data migration development, testing, and execution utilizing Database Management System (DBMS) and ETL tools and technologies for structured and unstructured content such as Microsoft SQL Server Management Studio, Experian Pandora, and Aperture Data Studio.

Desirable Experience :

1. Experience in preparing a long-term Data Integration Plan involving data migration between SQL Server and Oracle systems.
2. ​​​​​​​Background in maximizing security with regard to PII data and encryption during data migration cleansing, data loading and validation.
3. Familiarity with Microsoft Project.

Equal Opportunity Employer:

At Capio Group, our employees are our greatest asset and diversity, equity, and inclusion are at the core of who we are. Our commitment to these values is unyielding and is central to our mission and to our impact. We know that having diverse perspectives helps to generate better ideas to solve the complex problems of our diverse clients and the communities they serve.