Data Engineer with AB Initio exp (Remote)
About The Position
The Data Engineer defines and extracts data from multiple sources, integrates disparate data into a common data model, and loads it into target databases, applications, or files using efficient programming processes. The role develops scalable data pipelines for ingestion, cleansing, transformation, integration, and validation, preparing datasets for analysts and data scientists. The engineer documents, tests, and maintains data systems and processes; writes and refines code for reliable, performant data extraction and processing; and develops SQL queries for analysis and model construction. The role participates in requirements-gathering sessions, owns delivery of moderately sized data engineering projects, collaborates with cross-functional teams to resolve data quality and operational issues, and recommends database improvements and optimizations. This is a remote role limited to candidates residing in the states listed in the posting. The assignment duration is six or more months. Three years of continuous AB Initio experience is required; Snowflake and healthcare or insurance experience are preferred.
Requirements
- At least 3 years of continuous AB Initio experience.
- Bachelor's degree and 3 years of experience with data integration, data warehouses, operational data stores, data lakes, and big data platforms; alternatively, 5 years of the stated experience in lieu of a degree.
- Direct experience with at least one ETL development language or technology, such as Ab Initio, DataStage, Informatica, Python, or R.
- Advanced SQL knowledge.
- Experience with database technologies such as Snowflake, DB2, or AWS.
- Must reside in one of the states listed in the posting to work remotely: North Carolina, Alabama, Arizona, Arkansas, Colorado, Florida, Georgia, Idaho, Indiana, Iowa, Kansas, Kentucky, Louisiana, Maryland, Michigan, Mississippi, Missouri, Ohio, Oklahoma, Pennsylvania, South Carolina, South Dakota, Tennessee, Texas, Utah, Virginia, Wisconsin, or Wyoming.
Nice To Haves
- Snowflake experience.
- Healthcare or insurance experience.
Responsibilities
- Define and extract data from multiple sources, integrate disparate data into a common data model, and load it into a target database, application, or file.
- Document and test data systems that combine disparate sources and make data available to data scientists and other users.
- Write and refine code to ensure the performance and reliability of data extraction and processing.
- Participate in requirements-gathering sessions with business and technical staff to translate business requests into technical requirements.
- Develop SQL queries to extract data for analysis and model construction.
- Own delivery of moderately sized data engineering projects.
- Design and develop scalable, efficient data pipelines for data ingestion, cleansing, transformation, integration, and validation.
- Document and test data processes, including data validation and verification.
- Collaborate with cross-functional teams to resolve data quality and operational issues and ensure timely delivery.
- Develop and implement scripts for database and data process maintenance, monitoring, and performance tuning.
- Analyze databases and identify and recommend improvements and optimization.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
