Location: Remote/Champaign, IL
Duration: 3 Years
Work Schedule: Full Time
Salary: $81,931.00/Annum + Company Standard Benefits

Job Duties:

• Create and enhance data solutions enabling seamless delivery of data and is responsible for collecting, parsing, managing and analyzing large sets of data across different domains for analysis.
  • Works with various departments in collecting requirements and creates tables to load data based on business requirements. Manages data in Development, QA and PRODUCTION environments ensuring seamless delivery to the customers.
• Use different Data warehousing concepts to build a Data warehouse for internal departments of the organization.
  • Applies Data warehousing concepts such as star and snowflake schema approach while creating tables and maintaining data to ensure data integrity.
• Designs and develops data pipelines, data ingestion and ETL processes that are scalable, repeatable and secure for stakeholder needs.
  • Designs ETL Processes using Informatica tool to extract data from heterogeneous sources and transforms data using complex logic as per business needs and ingests it into our warehouse.
• Build Data architecture to support data management strategies to support business intelligence efforts for various stakeholders.
  • Ensures data stored in the warehouse can be used to create dynamic Business Intelligence reports for complex analysis helping in making business driven decisions.
• Leads the design of the logical data model and implements the physical database structure and constructs and implements operational data stores and data marts.
  • Manages access to confidential data by creating database views and data marts for customers and ensures confidential data is shared using company policies.
• Support deployed data applications and analytical models by being a trusted advisor to Data Scientists and other data consumers by identifying data problems and guiding issue resolution Data Pipeline Management.
  • Works with other team members in analyzing the data and advises on how to improve data quality and provide cleaner solutions to business stakeholders.
• Develops real-time and batch ETL data processes aligned with business needs, manages and augments data pipeline from raw OLTP databases to data solution structures.
  • Builds complex ETL process using Informatica to transform the data as per business needs and automated the process capturing real time data and maintaining history for complex analysis.
• Document’s data flow diagrams, security access, data quality and data availability across all business systems.
  • Documents all processes of every project using JIRA for reference by any other member on the team and ensures it is always secure.

Minimum Requirement: This position requires minimum of Bachelor’s degree in computer science, computer information systems, information technology, or a combination of education and experience equating to the U.S. equivalent of a Bachelor’s degree in one of the aforementioned subjects.