Understands data needs and advise company on technological resources. Aggregate and analyze various data sets to provide actionable insight. Develop reports, dashboards, and tools for business-users. Develop technical solutions to improve access to data and data usage. Develops and executes ETL code and ensures that the data loading processes are reliable and data quality remains high.

ESSENTIAL FUNCTIONS:

Writes and executes ETL code, primarily complex SQL/NoSQL script, but with a strong ability to leverage other technologies.
Analyzes and validates existing routines and communicates impacts. Assists with data transformation, manipulation, and presentation to users.
Works with Business Analysts, Business Intelligence Developers, Infrastructure Architects, and key business users to review, design, and develop data models and ETL processes.
Supports the Software Engineering team with data analysis and validation with extensive SQL queries.
Designs, configures, implements, monitors, and manages all aspects of Data Integration Framework.
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.
Defines Data Integration best practices for the data management environment.

SUPERVISORY RESPONSIBILITY:

This position has no direct reports, however, may informally lead teams in a matrix environment.

QUALIFICATIONS:

Education Level: Bachelor's Degree in 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 OR in lieu of a Bachelor's degree, an additional 4 years of relevant work experience is required in addition to the required work experience.
Knowledge, Skills and Abilities (KSAs)
Knowledge, understanding, and development experience in Informatica IICS ETL tool. Informatica PowerCenter knowledge is a nice-to-have.
Knowledge, understanding, and development experience in writing SQL queries and Snowflake experience preferred. Oracle and/or SQL Server knowledge is a nice-to-have.
Experience developing in a DevOps environment utilizing CI/CD.
Knowledge and understating of troubleshooting and resolving ETL code issues.
Knowledge and understanding of cloud platforms (Azure preferred).
Knowledge and understanding of at least one programming language (i.e., SQL, NoSQL, Python)
Knowledge and understanding of data exchange formats
Knowledge and understanding of database design and implementation concepts
Ability to recognize, analyze, and solve a variety of problems
Knowledge and understanding of data movement concepts
Excellent communication skills both written and verbal
Must be able to effectively work in a fast-paced environment with frequently changing priorities, deadlines, and workloads that can be variable for long periods of time.
Must be able to meet established deadlines and handle multiple customer service demands from internal and external customers, within set expectations for service excellence.
Must be able to effectively communicate and provide positive customer service to every internal and external customer, including customers who may be demanding or otherwise challenging.