Senior Data Architect

Senior Data Architect

Schaumburg, IL

12 Months

Onsite role and we need locals or nearby resources only

Job Description Senior Data Architect

Responsibilities

• Maintaining a solid understanding of the company's data model and the ability to design solutions and processes which combine disparate data into meaningful reporting and analysis for customers and internal audiences.
• Understanding complex data relationships and business requirements and formulate efficient and reliable solutions to difficult problems.
• Communication and analytical skills to work with business owners, stakeholders, developers, and DBAs.
• Design and implementation of relation and star schema modelling.
• Articulating data definitions, content domains, data classes, subject area classification, and conformed dimensions.
• Collecting, maintaining, and publishing corporate metadata related to the modelling.
• Enforcing data governance standards, policies, and procedures for the design and proper use and care of data
• Developing, managing, and updating data models, including physical and logical models of the data warehouse, data mart, staging area, and the operational data store and source systems
• Working with business owners to define and understand business requirements of the enterprise data warehouse.
• Understanding the company's transactional system and data sources and identifying gaps in business processes
• Ensuring data accuracy in the early life cycle of the project.
• Performing data modelling based on Dimensional Fact Model (DFM) principle.
• Assisting in the design of the company's data extraction, staging, and loading to data warehouse processes to ensure that data is as consistent, clean, and accurate as possible.
• Acting as a key liaison to the company's Data Management Leader and developers, developing solutions to design problems, increasing efficiency and performance, and recommending best practices for data warehouse-driven reporting and analytics
• Developing technical documentation including requirements documents, process overviews, and data models/data flow.
• Interacting with data stewards for data definitions, consistency, quality, privacy, security, and conflict resolution

Qualifications

• Strong math and analytical skills are essential to complete job requirements successfully.
• Able to compile and organize statistical information retrieved and present findings to management.
• Strong computer skills and ability to use necessary databases and software.
• Interpersonal and customer service skills are required when meeting with and interviewing potential clients.
• Excellent multitasking skills and task management strategies
• Ability to complete milestones and work toward multiple deadlines simultaneously.
• Bachelor's degree in computer science or related field
• 10+ years of experience in database development, information systems design and analysis
• experience with database technologies and the design and implementation of enterprise-level data modelling/data architecture of data warehousing and the support of business intelligence initiatives.
• Hands on experience with data modelling
• 5+ years of experience data modelling, designing, implementing, and performance management of large-scale data warehousing initiatives.
• Strong grasp of advanced SQL writing and query tuning/optimization
• Strong documentation skills (source-to-target mappings, LDM, PDM, etc)
• Strong written / oral communication and organizational skills Responsibilities