STEM Expert
Healthcare & Life SciencesDirect SmartRecruiters career site

Data Architect

Location
Detroit, MI
Job type
Full-time
Level
Director
Experience
10+ years
Education
Bachelor's degree
Listed
Yesterday

Skills & highlights for this role

  • ETL tools (DataStage/Informatica/AbInitio)
  • SQL/PL-SQL
  • data architecture
  • master data management
  • Unix scripting

Also useful

  • Erwin
  • Netezza/Vertica/Exadata
  • Zachman/TOGAF
Free · No account needed

How well does your resume fit this job?

Upload your resume to see your score for this STEM Expert role, what matches, what's missing, and your best other matches.

Scored on our server and not saved there. The file stays in this browser so you don't have to upload it again after you sign up.

General Roles/Responsibilities

  • ¿ Works on multiple highly complex projects/ programs/domains that require in-depth knowledge of Data Warehousing/BI and Information Architecture disciplines.
  • ¿ Works as a team lead or internal consultant.
  • ¿ Viewed as an expert and provides knowledge and counsel to others.
  • ¿ Provides strategic consultation to clients and IT teams.
  • ¿ Participates in quality reviews and provides feedback.
  • ¿ Conduct analysis of organizational needs and goals for the development and implementation of application systems
  • ¿ Advises on options, risks, costs versus benefits, system impacts, and technology priorities.
  • ¿ Works with business leaders to understand business requirements and help them understand how technology tradeoffs influence strategy.
  • ¿ Keeps IT¿s technology and delivery managers aware of key technical and customer issues, identifying and resolving potential problems and conflicts.
  • ¿ Contributes to post-implementation continuous-improvement efforts to enhance performance and provide increased functionality.
  • ¿ Ensures the conceptual completeness and architectural alignment of the technical solution and oversees it from inception to its implementation.
  • ¿ Works closely with project management to ensure alignment of plans with what is being delivered.
  • ¿ Develops, motivates, coaches and mentor IT members to create a team environment.
  • ¿ Recommends training programs targeting specific areas of improvement.
  • ¿ Participates in the DW/BI architecture Governance process.
  • ¿ Reviews exceptions and makes recommendations to architectural standards at a domain level.

Qualifications & Requirements

Education And/or Experience

  • Bachelor’s degree in Computer Science, Information Systems, Computer Engineering, Systems Analysis or a related field required. Master’s degree preferred.
  • 10 years of experience in multiple IT areas with 5 - 7 years of relevant domain experience in data warehousing is required.
  • Must have expert level knowledge of a. ETL tools like Data stage / Informatica / AbInitio b. Unix scripting, SQL, PL/SQL c. Working with several databases like Oracle, DB2, SQL server, Teradata d. Data architecture and Master data management processes e. Experience in one or more databases (eg. Oracle, DB2, SQL server) is required f. Experience in one or more of major BI Reporting tools (eg. Business Objects, Cognos) is required.

Additional information

g. Experience in Architecture frameworks (Zachman, TOGAF), conceptual solution preparation and realization of the solution during the design and build is required h. Experience in one or more of major data modeling tools (eg. Erwin, Data Architect) preferred.

i. Experience in one or more major MDM tools preferred.

j. Experience in designing solutions in one or more appliances (eg. Netezza, Vertica, Exadata) preferred

  • Requires expert level knowledge and understanding of data warehouse architecture, application design, systems engineering, SDLC and integration.
  • Must have lead the design and architecture of end to end implementations of several large scale data integration, data mart, reporting and MDM projects.
  • Healthcare experience is required

Additional Information: Specific Roles/Responsibilities

  • Data warehouse Solutions Architecture
  • ¿ Contributes to the development of end-to-end data warehouse solutions that deliver capabilities to the enterprise.
  • ¿ Analyzes enterprise business drivers to determine corresponding Information Architecture change requirements.
  • ¿ Coordinates with other specific architect types (Enterprise Architects, Data architects, Security Architects) to ensure alignment.
  • ¿ Defines the principles to guide ETL / reporting solution decisions for the programs / projects leveraging DW/BI architecture artifacts.
  • ¿ Coordinates ETL / reporting solution architecture implementation and modification activities.
  • ¿ Designs and governs the implementation of ETL Architecture based on DW/BI business requirements and IT strategies.
  • ¿ Facilitates in the evaluation and selection of software product standards, as well as the design of standard software configurations.
  • ¿ Consults with application or infrastructure projects to ensure alignment with solution architecture and coordination across architecture disciplines.
  • ¿ Identifies exceptions to established architecture principles, guidelines and standards including determining corrective action plans. Work within established governance practices to secure resolution.
  • ¿ Works with project team to assure architectural alignment and identifies opportunities for reuse.
  • ¿ Supports the development of architectural models, target state of DW/BI and roadmap to attain the target state.
  • ¿ Analyzes the current architecture to identify weaknesses and develop opportunities for improvements.
  • ¿ Provides direction for the technical design, development, testing, implementation and maintenance of DW/BI systems.
  • ¿ Guides the technical team in identification and resolution of Data Quality issues
  • ¿ Mentors and provides technical direction to the project team throughout the SDLC.

Information Architecture

  • ¿ Guides the development and maintenance of data standards, policies and practices.
  • ¿ Develops guidelines and standards for cataloging and maintaining data repositories.
  • ¿ Maintains enterprise-wide integrity of the data model by ensuring that data design and transformation procedures are implemented and followed.
  • ¿ Guides the design of the data models, across multiple data types in alignment with the solution architecture.
  • ¿ Ensures compliance with data governance practices, which may include a data model, associated metamodel, common business vocabulary, ontologies and taxonomies.
  • ¿ Ensures regulatory issues are considered surrounding information assets (such as consumer privacy laws, data retention policies, outsourced data and specific industry guidelines are adhered to.
  • ¿ Facilitates the mapping and audit-ability of information assets.
  • ¿ Analyzes information to evaluate the effectiveness of controls, determine the accuracy of reports, and monitor the efficiency and security of operations.
Read the original posting

From STEM Expert's careers page, first listed on Rolev.ai on November 20, 2026. Rolev.ai is not the employer.

How Rolev.ai helps with this application

Rolev.ai is a job search and application tool for US job seekers. For this Data Architect role at STEM Expert, it shows how your resume fits, tailors your resume to the posting, and prepares the application for you to review.

  • See how you fit

    Openings from employer career sites are ranked against your whole resume—and searchable inside Claude, ChatGPT, and Cursor via Rolev.ai MCP.

  • Tailor without inventing

    Every change to your resume is checked against your original. New experience goes in only with your yes—zero fabricated claims.

  • Draft the full kit

    Tailored and Full Match resumes, role-specific cover letters, and answers to employer screening questions are prepared in seconds.

  • 1-Click Extension Autofill

    The Chrome extension fills the employer's Greenhouse, Workday, Lever, or Ashby form in 1 click. You review it and press Submit.

Common questions

Where is the Data Architect job at STEM Expert located?

This Data Architect position at STEM Expert is located in Detroit, MI. Always check STEM Expert's application page for specific state eligibility or relocation policies.

What qualifications are required for Data Architect at STEM Expert?

For the Data Architect role, STEM Expert highlights 10+ years of relevant experience; a bachelor's degree; experience with ETL tools (DataStage/Informatica/AbInitio), SQL/PL-SQL, data architecture, master data management, Unix scripting. Rolev.ai can score your existing resume against these requirements and show any skill gaps before you apply.

How do I apply for the Data Architect position at STEM Expert?

This listing links directly to STEM Expert's SmartRecruiters application page. You can apply directly on STEM Expert's site, or use Rolev.ai to check your resume fit, generate a zero-hallucination tailored resume and cover letter for this posting, and autofill the SmartRecruiters application form in 1 click with the Rolev.ai Chrome extension. You always review the form and press Submit yourself.