Sign up to access all features of our service.
  • Job search
  • Favorites
  • Create a CV
    New
  • Salaries
  • Subscriptions

Sr. Data Architect

HCL Global Systems

Sr. Data Architect

Under limited supervision, analyze complex data processing problems, and plan and design advanced computer applications; responsible for full SDLC; gather business requirements for database and application updates and changes; develop, validate and communicate OLTP and OLAP relational data modeling solutions; design and publish data models to view metadata information about tables and lineage between the data elements; create conceptual, logical and physical data models; implement metadata strategy and build metadata repository; maintain business rules, data dictionaries, data transformation rules; generate DDL scripts and provide them to the database administrators to implement on the database server; coordinate development of data warehouse, database, ODS and data marts; create templates, domains and naming standards for designing the data models; manage model mart efficiently to keep all versions of models up to date; provide required documents and generate business reports for ETL team; coordinate data cleansing and profiling; implement forward/reverse engineering techniques, and use database normalization; define and implement best practices for data retention, archival and purging; coordinate with ILG for newly created databases and tables, and classify them for internal purge and data archival process; create metadata repository of data elements in the data warehouse and data marts; mentor and assist less experienced team members; and use SQL Server, DB2, Teradata, Apache, Hadoop, Hive, HDFS, OLTP, OLAP, Toad, Erwin, Microsoft Azure, SSMS, SSIS, Power BI, Python and related tools.

Minimum Qualifications Education: Bachelor degree in Computer Science, Computer, Electronic, Electrical or Mechanical Engineering or in a related field of study (will accept equivalent foreign degree).

Experience: Five (5) years of progressive experience as a Software Developer, Systems Analyst, Computer Programmer or in a related occupation.

Other Requirements: Experience must include five (5) years of work with SQL Server, Teradata, Hadoop, HDFS and Erwin; must be willing to relocate.

Job Order No: 11098978.

***This position is eligible for a referral bonus through our employee referral program***

Vacancy posted 3 days ago
Similar jobs that could be interesting for youBased on the Sr. Data Architect in Farmington Hills, MI vacancy
  • EY is seeking a Senior Manager in Data Architecture to lead transformative projects in the automotive and aerospace sectors. In this role, you will ensure project delivery, manage timelines and costs, and engage with clients, enhancing both your skill set and career. The... 
    Senior

    EY

    Southfield, MI
    4 days ago
  • EY is seeking a skilled professional to manage and deliver complex data architecture projects in the Power & Utilities sector. The ideal candidate will have over 12 years of consulting experience and expertise in cloud platforms such as Azure or GCP. This role requires... 
    Senior

    EY

    Southfield, MI
    4 days ago
  •  ...Data Architect, Farmington Hills, Michigan We are looking for a Data Architect that has some experience in application or integration development in your earlier formative years. Company Data Architects have experience outside of pure data. In addition, all candidates... 
    Suggested
    Relocation
    3 days per week

    Next Step Systems LTD

    Farmington Hills, MI
    1 day ago
  • $144k - $329.1k

     ...skill set to keep up with the ever‑growing demands of the modern data platform. During implementation you will solve complex...  ...quality solutions. Your responsibilities will include: As Data Architect - Senior Manager, you will have an expert understanding of data... 
    Senior
    Summer holiday
    Flexible hours

    EY

    Southfield, MI
    4 days ago
  • $144k - $329.1k

     ...skill set to keep up with the ever‑growing demands of the modern data platform. During implementation you will solve complex...  ...architecture and data engineering, focused on problem‑solving to design, architect, and present findings and solutions. Leading junior team... 
    Senior
    Summer holiday
    Flexible hours

    EY

    Southfield, MI
    4 days ago
  • $110k - $181k

     ...Join us.Your Role.Partner with business stakeholders, technology teams, and leadership to understand objectives, define business and data challenges, and align on practical data and analytics solutions.Lead discovery and solution design efforts, including defining... 
    Full time
    Flexible hours

    P&M Corporate Finance

    Southfield, MI
    4 days ago
  • Enterprise Data Architect Role Summary The Enterprise Data Architect is the design authority for Masco's enterprise POS and adjacent commercial data assets. This role owns the enterprise data model, the governed master data foundations, and the attribution logic that connects... 
    Full time
    Local area
    Flexible hours

    Masco

    Livonia, MI
    4 days ago
  •  ...Your Role Partner with business stakeholders, technology teams, and leadership to understand objectives, define business and data challenges, and align on practical data and analytics solutions. Lead discovery and solution design efforts, including defining requirements... 

    Plante Moran

    Southfield, MI
    2 days ago
  • The Sr. Staff Accountant position is primarily responsible for ensuring compliance with generally accepted accounting principles (GAAP...  ...(GAAP) and company accounting policies and procedures.Analyzes data and trends and prepares reports as needed.Maintains safety, security... 
    Senior
    Work at office

    RouteOne

    Farmington Hills, MI
    1 day ago
  • Job TitleJob Responsibilities:Modify existing application code or interfaces or build new application components from detailed requirements.Analysis of requirements, support of the design, development of the code, testing, debugging, deployment, and maintenance of those...
    Senior

    Software Technology Inc

    Farmington Hills, MI
    5 days ago
  • $99k - $134.3k

    Job SummaryWho We Are North American Lighting Inc., member of the Koito Group of Companies, is the largest tier one automotive exterior lighting manufacturer in North America. As the market share leader in exterior automotive lighting, NAL provides advanced lighting technology...
    Senior
    Local area
    Relocation package

    North American Lighting

    Farmington Hills, MI
    2 days ago
  • Job Description Job Description We are looking for an experienced Senior Auditor Consultant to join a consultant engagement supporting employee benefit plan audits within the financial services sector. This role is ideal for a public accounting specialist who can manage...
    Senior
    Contract work

    Robert Half

    Farmington Hills, MI
    9 days ago
  •  ...Sr. Software Engineer Onsite hiring for U3 band, PID: Y.IN2300809, NNA PWO FY23 Customer Experi, Requested by: Velavan Sathyamurthy(204566) Duties and Responsibilities: Lead UI (Angular)/UX redesign of the UXQA application Troubleshoot application issues... 
    Senior

    Keylent Inc

    Farmington Hills, MI
    3 days ago
  •  ...Sr. Network ArchitectUnder limited supervision, design and implement moderately complex enterprise data center networks in multi-vendor environments; gather data to identify client needs and use to identify, interpret, and evaluate system and network requirements; perform... 
    Senior
    Relocation

    HCL Global Systems

    Farmington Hills, MI
    5 days ago
  •  ...Plan, design, develop, and implement moderately complex company database(s)/ Install, configure, and manage databases. Identify data definition, structure, and long-range requirements. Complete documentation of database(s), including operational guidelines and protection... 
    Senior

    Software Technology Inc

    Farmington Hills, MI
    2 days ago
  • Job DescriptionAccount Manager responsible for revenue growth and design funnel growthDirect responsibility for driving Opportunity discovery, Design In, and Design Win revenue conversion - full funnel managementProcess RFQs and lead quotation processesNegotiation of annual...
    Senior
    Local area
    Remote work
    Flexible hours

    Renesas Electronics America

    Farmington Hills, MI
    3 days ago
  • Job-ID32311009Reference26-01614Job Title: (Sr. Testing Lead)About Kyyba:Founded in 1998 and headquartered in Farmington Hills, MI, Kyyba has a global presence delivering high-quality resources and top-notch recruiting services, enabling businesses to effectively respond... 
    Senior

    Kyyba

    Farmington Hills, MI
    4 days ago
  • $140k - $180k

     ...Data Platform Architect – Remote Bright Vision Technologies is a technology consulting and software development company delivering cloud, AI, data, and enterprise solutions across the United States. This is a fantastic opportunity to join an established and well-... 
    Full time
    H1b
    Local area
    Immediate start
    Remote work
    Visa sponsorship

    Bright Vision Technologies

    Farmington Hills, MI
    7 days ago
  • $100.5k - $165k

    Description You will be a key person interacting and influencing decision-makers of targeted customer organizations. This involves driving pre-sales technical discussions, presentations, demonstrations and negotiations, as well as on-going program management. The ideal...
    Senior
    Temporary work

    Omni Vision Inc

    Farmington Hills, MI
    2 days ago
  • $103.7k - $141.9k

     ...reports that outline the analysis and conclusions.Provides theoretical calculations for physical experiments, and substantiates them test data.Compares test data to theoretical models, and presents the results of the physical aspects of automotive lamps that were tested.... 
    Senior
    Work experience placement
    Local area
    Relocation package

    North American Lighting

    Farmington Hills, MI
    4 days ago
  • About Exponent Exponent is the only premium engineering and scientific consulting firm with the depth and breadth of expertise to solve our clients’ most profoundly unique, unprecedented, and urgent challenges. We are committed to engaging multidisciplinary teams of ...
    Senior
    Work at office
    Flexible hours

    Exponent

    Farmington Hills, MI
    4 days ago
  •  ...Sr. Mainframe DeveloperUnder limited supervision, perform complex design, development and implementation of mainframe and ETL applications...  ...application migration; set up test environments, manipulate test data and perform unit, system and other testing; perform code review... 
    Senior
    Relocation

    HCL Global Systems

    Farmington Hills, MI
    5 days ago
  • Masco Corporation in Michigan seeks an Enterprise Data Architect to own the enterprise data model, master data foundations, and attribution logic across BU, HQ, and retailers. You will establish semantic modeling standards and govern data quality, security, and metadata... 

    Watkins Wellness

    Livonia, MI
    1 day ago
  • About Exponent Exponent is the only premium engineering and scientific consulting firm with the depth and breadth of expertise to solve our clients’ most profoundly unique, unprecedented, and urgent challenges. We are committed to engaging multidisciplinary teams of ...
    Senior
    Work at office
    Flexible hours

    Exponent

    Farmington Hills, MI
    4 days ago
  •  ...Sr. .Net Developer Job Duties: Under limited supervision, develop, create, and modify complex distributed systems and applications...  ...work on multi-tier architecture; store, retrieve, and manipulate data for analysis of system capabilities and requirements; develop... 
    Senior
    Relocation

    HCL Global Systems

    Farmington Hills, MI
    2 days ago
  •  ...Sr. Quality EngineerPerform quality control on construction projects, prepare QA/QC Plans. Review specifications and RFI's. Prepare cost estimate for various projects for bidding and find vendors for various projects in local industry. Prepare construction plans using... 
    Senior
    Temporary work
    For contractors
    Local area
    Relocation

    HCL Global Systems

    Farmington Hills, MI
    4 days ago
  • Company DescriptionRobert Bosch LLC seeks Sr. Technical Project Manager (Multiple Positions) at its facility located at 38000 Hills Tech Dr, Farmington Hills, MI 48331. Technical responsibility for the customer project and acting as the technical window to the customer... 
    Senior
    Local area
    Remote work
    Work from home
    Worldwide
    3 days per week

    Robert Bosch

    Farmington Hills, MI
    3 days ago
  •  ...Sr. Software DeveloperUnder limited supervision, design, develop, test and implement complex web and enterprise applications; responsible for full SDLC; understand business requirements, convert into functional requirements and validate feasibility; develop proof of concepts... 
    Senior
    Relocation
    Flexible hours

    HCL Global Systems

    Farmington Hills, MI
    5 days ago
  •  ...Sr. QA Engineer Under limited supervision, develop and execute complex mainframe and distributed platform testing plans in various...  ...functional specifications and user requirements; coordinate STLC; write data requirements and develop test plans, cases, and scenarios;... 
    Senior
    Relocation

    HCL Global Systems

    Farmington Hills, MI
    3 days ago
  •  ...Sr. Java DeveloperUnder limited supervision, develop, create and modify complex, multi-tier, distributed enterprise applications and...  ...more efficient and maintainable software; write queries to pull data for testing; create end to end testing procedures with BDD; perform... 
    Senior
    Relocation

    HCL Global Systems

    Farmington Hills, MI
    5 days ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to Sr. Data Architect. Be the first to apply!