Data Architect

Details:

Stefanini Group is hiring!

Stefanini is looking for a Data Architect, Dearborn, MI (Onsite)

For quick apply, please reach out Pawan Rawat at 248-213-3605/pawansingh.rawat@stefanini.com

You will be responsible for designing, building and maintaining reliable, efficient and scalable data architecture and data models that serve as a foundation for all data solutions. You will closely collaborate with senior leadership and IT teams to ensure alignment of data strategy with overall business goals.

Key Responsibilities

• Develop conceptual, logical, and physical data models for business intelligence, analytics, and reporting solutions
• Transform requirements into scalable, flexible, and efficient data structures that can support advanced analytics
• Collaborate with business analysts, stakeholders, and subject matter experts to gather and interpret requirements for new data initiatives. Translate business questions into data models that can answer these questions
• Work closely with data engineers to integrate data from multiple sources, ensuring consistency, accuracy, and reliability. Map data flows and document relationships between datasets
• Design and optimize database schemas using the medallion architecture which includes relational, star schema and denormalized data sets for BI and ML data consumers
• Team with the data governance team so detailed documentation on data definitions, data lineage, and data quality statistics are available to data consumers
• Establish master data management data modeling so the history of how customer, provider and other party data is consolidated into a single version of the truth
• Serve as a bridge between technical teams and business units, clearly communicating the value and limitations of various data sources and structures
• Stay abreast of emerging trends in data modeling, analytics platforms, and big data technologies. Recommend enhancements to existing data models and approaches
• Monitor and optimize data models for query performance and scalability. Troubleshoot and resolve performance bottlenecks in collaboration with database administrators
• Ensure that data models and processes adhere to regulatory standards and organizational policies regarding privacy, access, and security
• Research and optimize data architecture technologies to enhance and support enterprise technology and data strategy
  
  

Details:

Experience Required

• 10 years in required skills
• Experience with Power Builder
• Experience with PostgreSQL
• Experience in Google Cloud Platform (GCP), Big Query
  
  

Experience Preferred

• Must have experience presenting technical material to business users
• Must be able to envision larger strategies and anticipate where possible synergies can be realized
• Experience acting as the voice of the architecture/data model and defend its relevancy to ensure adherence to its principles and purpose
  
  

Education Required:

• Bachelor's Degree
• Listed salary ranges may vary based on experience, qualifications, and local market. Also, some positions may include bonuses or other incentives***
  
  

Stefanini takes pride in hiring top talent and developing relationships with our future employees. Our talent acquisition teams will never make an offer of employment without having a phone conversation with you. Those face-to-face conversations will involve a description of the job for which you have applied. We also speak with you about the process, including interviews and job offers.

About Stefanini Group

The Stefanini Group is a global provider of offshore, onshore and near shore outsourcing, IT digital consulting, systems integration, application, and strategic staffing services to Fortune 1000 enterprises around the world. Our presence is in countries like the Americas, Europe, Africa, and Asia, and more than four hundred clients across a broad spectrum of markets, including financial services, manufacturing, telecommunications, chemical services, technology, public sector, and utilities. Stefanini is a CMM level 5, IT consulting company with a global presence. We are a CMM Level 5 company.