What are the responsibilities and job description for the Data Warehouse Developer position at Codeworks L.L.C?
Codeworks is an IT Services firm headquartered in SE Wisconsin, known for our strong commitment to quality and for our direct client relationships.
Who We’re Looking For:
We are seeking an experienced Data Warehouse Developer III to assist with the initial setup, configuration, and modeling of a new data warehouse using Redshift or Snowflake. This role will support the development of a new academic and administrative data warehouse (AADW) as part of a broader transition to Workday. The Data Warehouse Developer will work closely with the data warehouse team, BI developers, software engineers, and external partners to ensure the efficient development and maintenance of the data warehouse environment.
Responsibilities:
Develop and implement data warehouse design, including data architecture, metadata, and repository creation.
Design, develop, and maintain relational databases for data storage, integration, and data mining.
Assist with the initial data transfers to the new data warehouse.
Ensure the security and performance of the data warehouse, with an emphasis on continuous improvement in functionality.
Qualifications:
Qualifications:
Who We’re Looking For:
We are seeking an experienced Data Warehouse Developer III to assist with the initial setup, configuration, and modeling of a new data warehouse using Redshift or Snowflake. This role will support the development of a new academic and administrative data warehouse (AADW) as part of a broader transition to Workday. The Data Warehouse Developer will work closely with the data warehouse team, BI developers, software engineers, and external partners to ensure the efficient development and maintenance of the data warehouse environment.
Responsibilities:
Develop and implement data warehouse design, including data architecture, metadata, and repository creation.
Design, develop, and maintain relational databases for data storage, integration, and data mining.
Assist with the initial data transfers to the new data warehouse.
Ensure the security and performance of the data warehouse, with an emphasis on continuous improvement in functionality.
Qualifications:
Qualifications:
5 years of experience in multi-system data integration
Proven experience with data integration through Extract, Transform, Load (ETL) & Extract, Load, Transform (ELT) patterns
Strong experience with data modeling and relational database design
In-depth knowledge of data warehouse architecture, maintenance, and auditing/logging
Experience with enterprise data integration tools such as Informatica Intelligent Cloud Services (IICS) Data Integration, Informatica PowerCenter, or dbt (preferably IICS)
Familiarity with structured and unstructured data
Experience working with cloud data storage platforms (e.g., Snowflake, Redshift)
Knowledge of data virtualization platforms (e.g., Denodo)
Strong written and verbal communication skills
Associate’s or Bachelor’s Degree in a related field preferred.
About Codeworks: Codeworks has over 25 years of experience serving Fortune 1000 companies in Wisconsin as well as our client's national locations. Our recruiting team excels at evaluating, advising, and connecting IT professionals with new opportunities that will satisfy their expectations regarding income and opportunity for growth. At Codeworks, we're committed to diversity, equity, and inclusion in our workforce and beyond. We believe in equal opportunities and value the unique perspectives that every individual brings to our team. Join us in creating an inclusive, innovative, and collaborative workplace where your talents can thrive.
Proven experience with data integration through Extract, Transform, Load (ETL) & Extract, Load, Transform (ELT) patterns
Strong experience with data modeling and relational database design
In-depth knowledge of data warehouse architecture, maintenance, and auditing/logging
Experience with enterprise data integration tools such as Informatica Intelligent Cloud Services (IICS) Data Integration, Informatica PowerCenter, or dbt (preferably IICS)
Familiarity with structured and unstructured data
Experience working with cloud data storage platforms (e.g., Snowflake, Redshift)
Knowledge of data virtualization platforms (e.g., Denodo)
Strong written and verbal communication skills
Associate’s or Bachelor’s Degree in a related field preferred.
About Codeworks: Codeworks has over 25 years of experience serving Fortune 1000 companies in Wisconsin as well as our client's national locations. Our recruiting team excels at evaluating, advising, and connecting IT professionals with new opportunities that will satisfy their expectations regarding income and opportunity for growth. At Codeworks, we're committed to diversity, equity, and inclusion in our workforce and beyond. We believe in equal opportunities and value the unique perspectives that every individual brings to our team. Join us in creating an inclusive, innovative, and collaborative workplace where your talents can thrive.
Codeworks is an Equal Opportunity Employer and considers applicants for all positions without regard to race, color, religion or belief, sex, age, national origin, citizenship status, marital status, military/veteran status, genetic information, sexual orientation, gender identity, physical or mental disability or any other characteristic protected by applicable laws.
#LI-KN1
Salary : $50 - $68
