Data Warehouse Developer

MROADS

Cohassett Beach, WA

JOB DETAILS
JOB TYPE
Full-time
SKILLS
Access Control, Agile Programming Methodologies, Amazon Web Services (AWS), Business Analysis, Business Intelligence, Business Support, Cloud Computing, Data Analysis, Data Management, Data Mart, Data Modeling, Data Processing, Data Quality, Data Warehousing, Database Extract Transform and Load (ETL), Dimensional Modeling, Documentation Models, Enterprise Architecture, Informatica, Information/Data Security (InfoSec), Machine Learning, Metadata, Performance Tuning/Optimization, Process Modeling, Query Optimization, Regulatory Compliance, Reporting Dashboards, Requirements Management, SQL (Structured Query Language), Scalable System Development, Scrum Project Management and Software Development, Security Monitoring, Snowflake Schema, Sprint Planning, Standup Meetings, Star Schema, Stored Procedures, Training Data Sets
LOCATION
Cohassett Beach, WA
POSTED
6 days ago
DescriptionOverviewWe 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. The ideal candidate has strong experience with ETL/ELT processes, data modeling, SQL optimization, and modern cloud-based data platforms.Key Responsibilities• Design, build, and maintain enterprise data warehouse architectures and data marts• Develop and optimize ETL/ELT pipelines to integrate data from multiple source systems• Create and maintain dimensional and relational data models (star/snowflake schemas)• Write, tune, and optimize complex SQL queries, stored procedures, and views• Ensure data quality, accuracy, and consistency through validation and monitoring• Collaborate with data engineers, analysts, BI developers, and business stakeholders to gather requirements• Support reporting, dashboarding, and analytics needs across the organization• Implement performance tuning, indexing, and partitioning strategies• Manage data security, access controls, and compliance requirements• Document data models, pipelines, and warehouse architecture• Participate in Agile ceremonies including sprint planning, standups, and retrospectivesRequired Qualifications• 5+ years of experience as a Data Warehouse Developer or in a similar data-focused role• Advanced proficiency in SQL• Strong development experience with informatica IDMC CDI and CAI is required• Strong understanding of data warehousing concepts, including dimensional modeling• Experience working with large-scale datasets and performance optimization• Familiarity with Agile/Scrum development methodologiesPreferred / Nice-to-Have Skills• Experience with cloud data platforms such as:o AWS• Experience supporting machine learning or advanced analytics workloads• Understanding of data governance, metadata management, and lineage

About the Company

M

MROADS