Levi, Ray & Shoup, Inc. Data Architect in Rolling Meadows, Illinois
LRS has prospered for over 30 years because our corporate philosophy embraces honest, ethical and hard-working people. If that describes your approach to IT consulting, we need to talk! LRS Consulting Services is seeking a Data Architect for a 9 month contract opportunity with our client in Chicago, IL!
The Data Architect will be expected to leverage their deep technical knowledge of data modeling and data integration best practices along with cross industry data expertise to empower the business to make data-driven decisions.
Work involves moderate to highly complex efforts in an agile environment to make the company’s long-term data strategy a success. This includes the development and delivery of our long-term strategic goals with a strong data architecture vision in collaboration with business users, department managers, technology leaders, and other key stakeholders.
Direction is received from the Manager, Data Services.
Essential duties to be performed with or without reasonable accommodation
Translates and transforms business requirements into data models (Conceptual, Logical and Physical)
Analyze source system data using profiling tools.
Expert knowledge in dimensional data modeling, ETL processes, data integration applications and business intelligence tools. SAP Business Objects and Tableau a plus.
Interacts with OLTP systems and translated relational models into dimensional models.
Maintains Data Model repository.
Drives conversations with development teams and DBA teams to optimize the schema structure and ingestion processes influencing the write and read performance.
Participates in collaborations to transform business requirements into ETL and data validation designs. This includes knowledge sharing and mentoring fellow team members.
Executes and provides feedback for data modeling policies, procedure, processes and standards.
Evaluates source system data and data models
Assists with capturing and documenting system flow and other pertinent technical information about data database design and/or systems
Design data models in Data Modeling tools (ErWin preferred)
Knowledge of RDBMS platforms (e.g. SQL Server or Hadoop) with experience in generating DDL
Experience with software quality assurance testing, release procedures, coding design and documentation protocol.
Address data related problems in regards to systems architecture, integration, compatibility, and multiple-platform integration.
Understanding of the systems development life cycle
Experience working in on an Agile team (preferably Scrum) of Agile terminology and practices such as User Stories, Backlog, Scrum, and Acceptance Criteria.
Experience with an Agile Tool such as Team Foundation Server (TFS) to track stories and code quality.
Bachelor’s degree in Computer Science or a related field
A strong background in establishing a Data Quality framework and architecture in accordance with existing company policies, procedures, and guidelines.
Solid experience using Informatica PowerCenter in a Data Warehouse environment. Experience in Informatica Data Transformation a plus.
Expert understanding of join logic, performance and query optimization in Informatica.
Expertise in using partitioning, transformations, and incremental caching in Informatica.
Experienced in being the lead designer of data mappings, transformation, and movement routines. This includes detailed designs, technical specifications, and transformation rules.
Experience in Perl or PowerShell for scripting
Highly proficient in writing and tuning complex SQL (T-SQL in SQL Server)
Strong experience with SQL Server 2014/2016
Proven success working in a collaborative and agile environment (Scrum methodology a plus).
Demonstrates analytical thinking and strong problem solving skills.
Strong working knowledge across the technology stack including ETL, data analysis, metadata, data quality, audit and design.
Experience or exposure to Informatica Metadata Manager, SAP Business Objects & Crystal, Tableau, Hadoop, and CA ErWin.
Proven background designing and architecting ETL solutions as part of a cross-functional team.
Experience in making hardware recommendations, sizing, and configuration for development systems.
Experience in Hybrid Cloud based implementations and architecture. Azure experience a plus.
Platforms: MS Windows on VMWare
Database Management Systems: Microsoft SQL Server 2012/2014/2016
Data integration: Informatica PowerCenter ETL, Informatica Data Transformation Tool, and HortonWorks (Hadoop background a plus)
BI Reporting and Visualization: SAP Business Objects & Tableau
Job Scheduling: SMA Solutions OpCon
SQL, Strong SQL/T-SQL, MS PowerShell scripting
File Movement: GO Anywhere Managed File Transfer
Experience working with SharePoint
Azure/AWS Cloud experience a plus
Agile Development – Scrum Methodology
LRS is an equal opportunity employer. Applicants for employment will receive consideration without unlawful discrimination based on race, color, religion, creed, national origin, sex, age, disability, marital status, gender identity, domestic partner status, sexual orientation, genetic information, citizenship status or protected veteran status.