Data Warehouse Engineer

Data warehouse engineer page is loaded## data warehouse engineer remote type:
hybrid locations:
uncasville, cttime type:
full time posted on:
posted todayjob requisition :
r-12373
** join our team and experience endless career possibilities
**** if you are an existing team member,*
* ** please click the following link to be taken to the internal career site:
**** position summary:
** the data warehouse engineer is responsible for designing, developing, and maintaining enterprise data warehouse infrastructure and etl (extract transform load) solutions that support strategic decision-making and operational efficiency. This role requires expertise in data integration, database management, and modern data engineering. The position will work closely with business stakeholders and cross-functional teams to understand requirements, implement scalable data solutions, and ensure the availability of high-quality data assets for business intelligence and analytics initiatives.
** primary duties and responsibilities****:**
* ** etl development and data integration:
** the data warehouse engineer will be responsible for designing, developing, and maintaining complex etl workflows using enterprise-class tools such as informatica. This includes extracting data from multiple source systems, applying business transformation logic, and loading data into target data warehouse environments. The role requires implementing automated validation procedures to ensure data accuracy and integrity across all warehouse feeds, as well as developing python scripts and apis for data integration, automation, and custom data processing tasks.
* ** data warehouse design and optimization:
** a core responsibility of this role is to design and maintain efficient data warehouse structures, schemas, tables, views, and materialized views that support business intelligence requirements. The data warehouse engineer will be responsible for performance planning, tuning, and optimization including warehouse sizing, query optimization, clustering keys, and data partitioning strategies. This includes implementing best practices for data modeling, leveraging features such as time travel, zero-copy cloning, and data sharing capabilities to ensure query efficiency and system scalability.
* ** technical documentation and data governance:
** the data warehouse engineer will create and maintain comprehensive technical documentation including data catalogs, structural diagrams, etl process flows, and data lineage documentation. This includes documenting data definitions, business rules, transformation logic, and end-user warehouse assets to ensure transparency and support data governance initiatives across the organization.
* ** business intelligence support and collaboration:
** provide level iii technical support for business intelligence and decision support tools, working directly with business users to troubleshoot complex data issues. Collaborate with business stakeholders and management to understand analytical requirements and translate them into technical specifications. Develop reports and data visualizations using enterprise reporting tools, ensuring that data assets are meaningful, efficient, and accurate for end-user consumption.
* ** data pipeline development and api integration:
** design and implement modern data pipelines that integrate with various systems through apis and web services. Develop python-based solutions for data extraction, transformation, and automation tasks. Leverage data warehouse’s native capabilities for continuous data ingestion, streams and tasks for data pipeline orchestration, and external functions for api integration. Work with other teams to ensure seamless integration of new data sources and maintain the reliability of existing data flows in a 7x24x365 enterprise environment.
* ** project execution and continuous improvement:
** execute approved work requests based on business priorities, working on project teams to create or modify existing data reports and warehouse assets. Stay current with emerging technologies, tools, and methodologies in data warehousing and data engineering, particularly snowflake and informatica…