View all jobs

Data Architect / ETL Architect

Kansas City, MO · Information Technology
Title: Data Architect / ETL Architect
Location: Kansas City, MO 64111
Terms: 2-5 Year Consulting Engagement
Contract Rates: Commensurate with Experience
Status: Prefer W2 or 1099 - No Corp to Corp with 3rd Parties

My company, Covenant Consulting is in an exclusive partnership with the company that was awarded a major exclusive multi-year technology modernization effort with a beloved brand in KC.  We are now seeking the strongest data talent in the entire region to fill several roles.  I'm looking for a hybrid data professional with architecture and ETL background (SQL and/or Informatica).  Our client is undergoing a huge data modernization effort that is expected to last 2-5 years.

We can work 1099 or hourly W2, benefits available.

Major Responsibilities:
•    A key responsibility for this candidate will be to architect the process for fast ingestion of data sources into an Enterprise Client Data Warehouse leveraging Informatica and SQL developer skillsets.

•    Work with other stakeholders to architect, design, develop, install, and maintain data structures and applications to solve business problems.

•    Skilled in warehouse development using either Kimball or Inmon methods.

Staff within the Information Technology department are required to consistently demonstrate the appropriate level of proficiency in the following competency areas: 
  • Change Advocate
  • Communication & Understanding
  • Accountability (for self and others)
  • Achievement Orientation
  • Personal Leadership
  • Business Adeptness
  • Client Orientation
  • Project/Program Management
  • Teamwork
  • Developing People
  • Technical Leadership

Distinguishing Characteristics:
•    A proven track record of career progression and success.
•    Superior interpersonal skills including the ability to communicate with individuals at all levels of the organization in both verbal and written form.
•    Willingness to continue to learn new technologies and to become an expert in all aspects of the business areas supported.
•    Highly motivated self-starter.
•    Strategic and innovative thinker.
•    Ability to work independently and as a member of a team.
•    Ability to provide technical and business guidance to technical and non-technical staff.
•    Good communication skills and customer relationship skills.

Education & Experience:

•    A Bachelor’s degree preferably in Computer Science or Management Information Systems.
•    3+ years of experience with Data Architecture and ETL Development, preferably on a data warehouse initiative
•    Experience with ETL tools (i.e. Informatica, SSIS, Datastage, etc.), preferably Informatica
•    Understanding of information systems and data life-cycle management best practices and methodologies, formal systems engineering life cycle (SELC), and systems development life cycle (SDLC).

•    Experience with IBM Netezza, Oracle, SQL Server, DB2, AWS DB stack, and/or Hadoop.
•    Understanding of one or more data warehouse techniques, such as Kimball, Inmon, or Data Vault.
•    Experience with Master Data Management (MDM) technologies
•    Experience with Data Quality Tools, such as Informatica Data Quality Tools
•    Experience working in a Financial Services firm specifically Asset Management.

Covenant Consulting is a Technology Services Provider offering project-based IT consulting, IT staffing and IT recruiting services. Every partnership reflects our uncompromising commitment to quality and integrity. We have extensive experience and capabilities in project-based consulting, short and long-term staff augmentation, and permanent recruitment. We work with companies of every size, across many industries and have the flexibility to scale solutions to meet our client's specific needs.

Covenant Consulting strives to attract, cultivate and retain exceptional talent. If you feel you are a match for the position, and are interested in a great growth opportunity, we encourage you to contact
Shannon McInnis
Sr. Technical Recruiter
More Openings
Plant Manager
SQL Developer
ETL Developer
Powered by