Data Engineer

Job Title: Cloud Data Engineer

Location: Columbus, OH 43215 (Hybrid)

Duration: 12 Months

Pay rate : $42.04 /hr - $ 78.57/hr on w2

M-F 8:00 AM - 5:00 PM

• 
  Schedule Expectations:Candidates must be local to the area at the time they are being submitted
• .Candidate must be flexible to work in the office (CWF who have had proven success work the hybrid schedule

• )
  Project Details & day to day in this position:Create, Update and Manage mapping documentation from legacy system to new syst
• emConduct code reviews and provide feedback to development te
• amTrouble shoot ETL failures and suggest solutio
• nsSupport planning development work in multi-workstream proje
• ctSupport data warehouse migration from on prem to clo

• ud
  Candidate Profile:Attention to deta
• il.Strong written & verbal ski
• llsSuccessful applicant must have experience documenting requireme
• ntsSuccessful applicant must have experience mapping data across syst
• emsSuccessful applicant must have demonstrated technical leadership on data t
• eamthis person will do less development and spend more time support, enabling and coordinating but they still need a very strong technical backgrou

• nd.
  Skills/Certifications/Technology (required)
• :ETLInforma
• ticaSQL Se
• rverdata mode

• ling
  Nice to Have:Informatica
• IDMCSnow
• flakeSQL S
• erverExperience supporting automotive Financial Services

• data
  BASIC QUALIFICATIONS:This position requires a Bachelor's Degree in Computer Science or a related technical field, and 5+ years of relevant employment exper
• ience.2+ years of work experience with ETL and Data Modeling on AWS Cloud Data
• bases.Expert-level skills in writing and optimizin
• g SQL.Experience operating very large data warehouses or data
• lakes.3+ years SQL S
• erver.3+ years of Informatica or similar techn
• ology.Knowledge of Financial Services ind

• ustry.
  PREFERRED QUALIFICATIONS:5+ years of work experience with ETL and Data Modeling on AWS Cloud Dat
• abases.Experience migrating on-premise data processing to AWS
• Cloud.Relevant AWS certification (AWS Certified Data Analytics, AWS Certified Database,
• etc.).Expertise in ETL optimization, designing, coding, and tuning big data processes using Informatica Data Management Cloud or similar techno
• logies.Experience with building data pipelines and applications to stream and process datasets at low lat
• encies.Show efficiency in handling data - tracking data lineage, ensuring data quality, and improving discoverability o
• f data.Sound knowledge of data management and knows how to optimize the distribution, partitioning, and MPP of high-level data stru
• ctures.Knowledge of Engineering and Operational Excellence using standard methodo

logies.
Responsib

ilities:The Cloud Data Engineer will be responsible for developing, expanding, and optimizing our data pipeline architecture, as well as optimizing data flow and collection for cross functional teams. The ideal candidate is an experienced data pipeline builder and data wrangler who enjoys optimizing data systems and building them from the ground up. During various aspects of this process, you should collaborate with coworkers to ensure that your approach meets the needs of each

project.To ensure success as a data engineer, you should demonstrate flexibility, creativity, and the capacity to receive and utilize constructive criticism. A formidable data engineer will demonstrate unsatiated curiosity and outstanding interpersonal

• skills.
  Key accountabilities of the function Leading Operations for Assigned Systems:Designing, implementing, and operating assigned cloud technology platforms as the technica
• l expert.Leading internal and external resources in the appropriate utilization of cloud technology p
• latforms.Executing ITSM/ITIL processes to ensure ongoing stable operations and alignment w
• ith SLAs.Steering providers in the execution of tier 2 and 3 support tasks
• and SLAs.Resolving escalated suppor
• t issues.Performing routine maintenance, administering access and securit
• y levels.Driving System Management & Application Mo
• nitoring.Ensuring monitoring and correct operation of the assigne
• d system.Ensuring changes to the system are made for ongoing run and
• support.Ensuring consolidation of emergency activities into regular mai
• ntenance.Analyzing system data (system logs, performance metrics, performance counters) to drive performance imp
• rovement.Supporting Agility & Customer Ce
• ntricity.Supporting the end user with highly available
• systems.Participating in the support
• rotation.Performing other duties as assigned by management Additional skills: special skills / technical abi
• lity etc.Demonstrated experience in vendor and partner ma
• nagement.Technically competent with various business applications, especially Financial Management
• systems.Experience at working both independently and in a team-oriented, collaborative environment is e
• ssential.Must be able to build and maintain strong relationships in the business and Global IT orga
• nization.Ability to elicit cooperation from a wide variety of sources, including central IT, clients, and other dep
• artments.Strong written and oral communicatio
• n skills.Strong interpersona