DataWarehouse Developer III
samprasoftPrinceton (NJ)
DataWarehouse Developer III
Posted 6 days ago
samprasoftPrinceton (NJ)
SENIORITY
Senior
About the role
Data Engineer/Architect 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's 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.
Before you apply
Applying takes about a minute. These four things decide how fast it moves after that.
Your profile is current
It's what we read first. Occupations, seniority and locations matter more than a long history.
Two examples you can talk through
Not a portfolio — just two pieces of work where you can explain the decisions and what you'd change.
A number in mind
What you're on now and what would make you move. We negotiate better when we know both.
Your notice period
Employers plan around it, and it's the question that stalls offers most often.
Once you apply, someone reads it and calls you before anything reaches the employer — usually within two working days.