Offer summary

Qualifications:

Extensive experience in relational databases, Proficient in SQL and ETL processes, Experience in documenting with ERDs, 5+ years of data transformation experience, Familiarity with Tableau and Business Objects.

Key responsabilities:

Lead business intelligence projects focused on data analysis

Develop and maintain Entity Relationship Diagrams (ERDs)

Design ETL processes for integration and transformation

Collaborate with teams to gather requirements

Ensure data accuracy using relational databases

Job description

Codeworks is an IT Services firm headquartered in SE Wisconsin, known for our strong commitment to quality and for our direct client relationships.

We are seeking a highly skilled and experienced Data Lead for a 100% remote role with residence in Wisconsin. The ideal candidate will possess extensive experience in relational databases, SQL, and ETL processes, along with strong communication skills to bridge business and technical teams. This position will involve working closely with business and technical stakeholders to document and understand complex data relationships, and develop efficient data transformation processes.

Key Responsibilities:

Lead and manage business intelligence projects, focusing on data analysis, modeling, and transformation.

Develop and maintain complex Entity Relationship Diagrams (ERDs) to document business and data relationships.

Design and oversee ETL processes for data transformation and integration.

Collaborate with business and technical teams to gather requirements and deliver solutions that meet organizational needs.

Utilize your expertise in relational databases and SQL to ensure data accuracy and integrity.

Provide guidance and support in the development and implementation of business intelligence solutions.

Top Skills & Experience Required:

Relational Databases & SQL experience.

Entity Relationship Diagrams (ERDs) experience in documenting and understanding complex data relationships.

Proven experience working effectively with both business and technical teams.

5+ years of experience in developing and understanding ETL processes for data transformation.

Familiarity with Tableau is a plus.

Experience with Business Objects is desirable.

Experience in technical writing with an emphasis on bridging business and technical needs.

Familiarity with data modeling tools (e.g., ERwin) and a strong understanding of ERDs and data modeling.

Experience with MS SQL Server and Oracle.

Experience with IBM DB2 is beneficial.

Demonstrated experience with Tableau and Business Objects.

In-depth experience with ERD creation and maintenance using ERwin.

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.

Required profile