Works directly and collaboratively with Lead Data Engineer/Architect and DSS Team members to create and maintain data solutions, platforms, databases, and data warehouses for all environments in the data ecosystem.
Analyzes business and technical requirements and data warehouse models, to understand the detailed data management requirements and collaborates on the design, planning and modification of data pipelines, stores, models, and other BI solutions.
Develop and maintain Data Repositories using multiple database programming skills on Oracle, Microsoft SQL Server, PostgreSQL, and Amazon Redshift
The incumbent will create, maintain, and tune packages, tables, and queries to optimize ETL and ELT processing with multiple data sources.
This role provides technical database expertise and problem-solving support to resolve Database Management issues and assist in the monitoring of database performance.
Provide business expertise for the development of Business Intelligence solutions
Provide technical expertise to the development and implementation of solutions using basic dimensional modeling techniques, make recommendations for improvements in these areas when necessary
Assure quality of design and implementation of projects
Trouble-shoot application software/hardware problems as they apply to design, implementation, or installation activities
Schedules and coordinate application maintenance activities.
Participate in on-call, overnight off-hour production problem resolution activities
Maintain Database Management related standards and procedures.
Research, evaluate, and test new Data Warehouse/Data Lake related tools and facilities.
Monitor current Data Warehouse applications and develop procedures, where necessary, to improve the environment as required
Identify and supports quality improvement initiatives
Comply with all security and audit standards
Proficient in one or more of following programming languages: Shell Scripting, SQL, Python, R, Java.
Experienced and knowledgeable with Microsoft SSIS, SSRS, and SSAS, Power BI.
Experienced and knowledgeable with AWS Lambda, S3, Glue, Athena, Redshift.
Data Warehouse Developer III