Match score not available

Data Warehouse Architect & ETL Developer

Remote:

Full Remote

Contract:

Fixed term

Experience:

Mid-level (2-5 years)

Work from:

United States

Offer summary

Qualifications:

Bachelor's or Master’s degree in Computer Science or related field, Strong experience in dimensional data modeling, 2+ years in large-scale data warehouse environments, Proficient in SQL and Oracle; experience in PL/SQL for ETL, Familiarity with Agile methodologies and DataStage ETL tools.

Key responsabilities:

Design and implement data mart models
Map source system models to data mart models
Develop and optimize ETL code for high-performance
Document ETL metadata, business rules, and validation processes
Collaborate with business users and cross-functional teams

Solomon Page Human Resources, Staffing & Recruiting Large https://www.solomonpage.com/

1001 - 5000 Employees

See more Solomon Page offers

Job description

Our client, a well-known retail apparel company, is looking for a Data Mart Model Designer & ETL Developer to join their team for a remote 12-month contract. We need a Data Mart Model Designer & ETL Developer to design, implement, and maintain data mart models and ETL processes. This role involves aligning source systems with data marts, writing and managing ETL code, and ensuring accurate data validation and transformation. You’ll work with various teams and handle profiling, metadata, and business rules in a dynamic setting.

Responsibilities:

Design and implement data mart models.
Map and align source system models with data mart models.
Develop, maintain, and optimize ETL (Extract, Transform, Load) code.
Define, capture, and document ETL metadata, business rules, and validation processes.
Profile source systems to ensure data integrity and accurate mapping.
Develop and maintain ETL validation logic and ensure the accuracy of data transformations.
Optimize ETL processes for performance and scalability in high-availability, large-scale data warehouse environments.
Collaborate closely with business users and lead cross-functional teams to deliver solutions.

Qualifications:

Bachelor's or Master’s degree in Computer Science or a related field.
Strong experience in dimensional data modeling.
2+ years of hands-on experience in large-scale, high-availability data warehouse environments.
Proficiency in SQL and Oracle with hands-on experience in writing complex transformation logic using PL/SQL for ETL business rules.
Experience with STAR schema design and ETL tools, particularly IBM Datastage.
In-depth knowledge of Oracle PL/SQL and SQL performance tuning in Oracle environments.
Familiarity with the software development life cycle, including Agile methodologies.
Experience with DataStage ETL tools (preferred).
Proficiency in MicroStrategy (strong plus).
Solid problem-solving skills and the ability to manage multiple projects and priorities effectively.
Strong communication skills and the ability to discuss project scope with business users.

Additional Skills:

Proficiency in shell scripting, SQL, XML parsing, and Unix environments.
Strong knowledge of data warehouse technologies, including Oracle, DB2, and IBM DataStage.
Experience in an Agile development environment (a plus).

If you meet the required qualifications and are interested in this role, please apply today.

The Solomon Page Distinction

Solomon Page offers a comprehensive benefit program for hourly employees. We pride ourselves on offering medical, dental, 401(k), direct deposit and commuter benefits to our employees, including freelancers - which sets us apart in the industries we serve.

About Solomon Page

Founded in 1990, Solomon Page is a specialty niche provider of staffing and executive search solutions across a wide array of functions and industries. The success of Solomon Page reflects an organic growth strategy supported by a highly entrepreneurial culture. Acting as a strategic partner to our clients and candidates, we focus on providing customized solutions and building long-term relationships based on trust, respect, and the consistent delivery of excellent results. For more information and additional opportunities, visit: solomonpage.com and connect with us on Facebook, and LinkedIn.

Opportunity Awaits.