ETL/Data Warehouse Developer in Princeton, NJ (Remote for now)
IT Recruiter
Hi,
ETL/Data Warehouse Developer
Location: Princeton, NJ (Remote for now)
Duration: Long term
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 ETS 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.