Description

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 Client 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

Bachelor's in Comupter Science or an equivalent degree.

Education

Bachelor's degree