Data Engineer
The Data Engineer plays a critical role in the successful execution of the client's data strategy. This role will be focused on data acquisition, curation, and transformation of data into a useable asset. They will work cross-functionally to develop and deploy optimized data models and modern data architecture in support of strategic data and business initiatives.
Job Duties and Responsibilities
- Creates detailed documentation of data warehouse, data stores, and end to end data flows
- Troubleshoots and corrects data and data processing errors in existing solutions
- Works with other technical teams as well as with internal and external users to develop technical designs
- Develops and continually refines the BI-focused data architecture
- Conducts gap analysis on source system databases against enterprise data warehouse in support of Business Intelligence efforts
- Develops and maintains data sets and standardizes data collection and processing methodologies
- Provides technical advice and weighs in on technical decisions that impact cross functional teams
- Attends and contributes to architecture meetings to determine project scope, time frame and cost estimates
- Works on plan and technical architecture to extract, integrate, and or push data to or from third party providers
- Provides enterprise data solutions including ETL maintenance, warehouse data models, periodic upgrades, security, governance, and performance optimization
- Understands the data warehouse and data mart models as well as being familiar with the business information contained in each
- Locates and defines new process improvement opportunities or alternative technologies that will enhance speed to business value delivery with our data
- Collaborates with developers and subject matter experts to establish the technical vision and analyze tradeoffs between usability and performance needs
Qualifications
- Bachelor's Degree required
- 1-3 years of experience in data and dimensional modeling
- 1+ years of experience in end-to-end data analysis and development
- 1+ years of experience with Informatica
- 1+ years of data warehouse experience
- Familiarity with Object Oriented Analysis, Project Management, Business Analysis Methodology and the SDLC
- Experience with cloud-based technologies and services (SaaS, PaaS, IaaS)
- Experience with Master Data Management
Required Skills : -Data Management -Informatica -Data Modelling
Basic Qualification :
Additional Skills :
Background Check :Yes
Drug Screen :Yes
Notes : This role is a more junior - mid level role; when submitting candidates, please do not submit individuals that are at the Architect level.
Selling points for candidate :
Project Verification Info :
Candidate must be your W2 Employee :Yes
Exclusive to Apex :No
Face to face interview required :No
Candidate must be local :No
Candidate must be authorized to work without sponsorship ::No
Interview times set :Yes
Type of project :Administration/Support
Master Job Title :Data Analyst
Branch Code :Indianapolis