Careers

Added Nov 05, 2021 Data Designer (22994) Central, IL | Contract Apply

Job Description

Looking for more than just another assignment? We're looking for you! This isn't just another assignment, but a real opportunity and a challenge for the right person. LRS Consulting Services is seeking a Sr. Data Designer for a 6-12 month contract opportunity with our client in Central Illinois!

LRS Consulting Services has been delivering the highest quality consultants to our clients since 1979. We have built a solid reputation for dealing with our clients and our consultants with honesty, integrity, and respect. We work hard every day to maintain that reputation, and we are very interested in candidates who can help us. If you're that candidate, this opportunity is made for you! .


The candidate requirements are:

Must have 8+ years of experience with the following:
  • Work with the business and technical stakeholders to define scope of Data-centric projects.
  • Hands-on experience in creating/updating conceptual, logical, and physical data models appropriately needed to satisfy both business and performance requirements
  • Experience designing OLTP and OLAP (both Star and Snowflake schemas) database models definition and optimization
  • Direct Data Designing/Modeling experience
  • Define new business and data definitions
  • Prepares ERDs, reports, charts, tables, and other analytic visualization to support business needs.
  • Reviewing Project Initiation Document, Reference/Domain value mapping.
  • Fluent in relational database concepts and flat file processing concepts
  • Ensure data models evolve to meet new and changing business needs
  • Providing detailed analysis on all new data model requests to ensure the solution is developed in an efficient manner and works properly with other applications within the system
  • Data mappings, transformation logic (for logical and physical models), and ongoing maintenance of the operational data stores and warehouses
  • Complex data integration and extraction/transformation/load processes (ETL).
  • Documenting the source to target mappings for data integration and web services.
  • Working with Business and Architects to identify Pain points impacting data capabilities.
  • Experience developing complex SQL queries from scratch
  • Creating and documenting data profiles to drive data modeling and source to target mappings analysis (conversion preparation analysis)
  • Working with enterprise partners to conduct complex data profiling using standardized tools.
  • Mapping configurations and complex data architectures, ensuring documentation meets current and forecasted needs
  • Evaluating information from many sources, provides recommendations, reconciles conflicts, cleans data into a consumable format and classifies the information into logical categories.
  • Using basic to moderate visualization techniques and skills to present findings of data exploration exercises.
  • Mapping the flow of data and the business processes and/or technical interfaces which would be created or impacted. Recommends solutions and adaptations as appropriate.
  • Aligning with data quality and transformation rules and develops infrastructure and/or other tools to communicate mapping to relevant groups.
  • Collaborating with project teams to ensure compliance with the Enterprise Data Governance policy and standards on information risk and data protection guidelines


- Candidate must be able to effectively communicate in English (written & verbal)

- Candidate must have permanent authorization to work in the USA for any employer

- Corp to corp candidates will not be considered.

Colorado salary range - $20/hr to $125/hr

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.