Data Warehouse Engineer
Role details
Job location
Tech stack
Job description
o We are seeking a skilled Data Warehouse Developer to design, develop, and maintain scalable data warehouse solutions that support business analytics, reporting, and data-driven decision-making o The ideal candidate has strong experience with ETL/ELT processes, data modeling, SQL optimization, and modern cloud-based data platforms., o Design, build, and maintain enterprise data warehouse architectures and data marts o Develop and optimize ETL/ELT pipelines to integrate data from multiple source systems o Create and maintain dimensional and relational data models (star/snowflake schemas) o Write, tune, and optimize complex SQL queries, stored procedures, and views o Ensure data quality, accuracy, and consistency through validation and monitoring o Collaborate with data engineers, analysts, BI developers, and business stakeholders to gather requirements o Support reporting, dashboarding, and analytics needs across the organization o Implement performance tuning, indexing, and partitioning strategies o Manage data security, access controls, and compliance requirements o Document data models, pipelines, and warehouse architecture o Participate in Agile ceremonies, including sprint planning, standups, and retrospectives, o informatica o etl o elt o sql o idmc o cdi o cai o cloud data integration o cloud application integration o data governance o metadata o aws
Requirements
o 5+ years of experience as a Data Warehouse Developer or in a similar data-focused role o Advanced proficiency in SQL o Strong development experience with Informatica IDMC, CDI, and CAI is required o Strong understanding of data warehousing concepts, including dimensional modeling o Experience working with large-scale datasets and performance optimization o Familiarity with Agile/Scrum development methodologies Preferred / Nice-to-Have Skills Experience with cloud data platforms such as: o AWS o Experience supporting machine learning or advanced analytics workloads o Understanding of data governance, metadata management, and lineage
Benefits & conditions
The Company offers the following benefits for this position, subject to applicable eligibility requirements: medical insurance, dental insurance, vision insurance, 401(k) retirement plan, life insurance, long-term disability insurance, short-term disability insurance, paid parking/public transportation, paid time off, paid sick and safe time, hours of paid vacation time, weeks of paid parental leave, and paid holidays annually - as applicable.