Job Description: Pay Range: $43hr - $48hr Essential Functions:
- 30% Writes and executes ETL code, primarily complex SQL script, but with a strong ability to leverage other technologies.
- 15% Analyzes and validates existing routines and communicates impacts.
- ssists with data transformation, manipulation, and presentation to users.
- 15% Works with Business Analysts, Business Intelligence Developers, Infrastructure Architects, and key business users to review, design, and develop data models and ETL processes.
- 10% Supports the Software Engineering team with data analysis and validation with extensive SQL queries.
- 10% Designs, configures, implements, monitors, and manages all aspects of Data Integration Framework.
- 10% Provides detailed guidance and performs work related to Modeling Data Warehouse solutions in the cloud OR on-premise.
- Understands Dimensional Modeling, Denormalized Data Structures, OLAP, and Data Warehousing concepts.
- 10% Defines Data Integration best practices for the data management environment.
Education Details:
- Information Technology or Computer Science or Engineering.
Experience:
- 3 years Hands-on experience with database management systems, ELT/ETL. systems, business intelligence tools, defect management and system testing.
- In Lieu of Education.
- In lieu of a Bachelor's degree, an additional 4 years of relevant work experience is required in addition to the required work experience.
Preferred Qualifications:
- Knowledge and understanding of at least one programming language (i.e., SQL, Python).
- Knowledge and understanding of data exchange formats.
- Knowledge and understanding of database design and implementation concepts.
- bility to recognize, analyze, and solve a variety of problems.
- Knowledge and understanding of data movement concepts.
- Excellent communication skills both written and verbal.