Data Scientist

Society of Exploration Geophysicists; Austin (TX); Remote; USD 90,000 - 130,000; Full time

Job summary

An established industry player is seeking an experienced Data Scientist to join their technical services team. This remote role involves analyzing and developing processes for the Enterprise Data Warehouse, ensuring data quality, and performing complex data analysis. Ideal candidates will have extensive experience with ETL processes, data modeling, and data science, particularly using Informatica and Oracle. Join a dynamic team where your expertise will significantly impact data-driven decision-making and reporting for various stakeholders. If you are passionate about data and looking for a challenging opportunity, this position is perfect for you.

Benefits

Medical Insurance

Life Insurance

401(k) Matching

Cafeteria Plan

Qualifications

• 8 years of experience in ETL processes and data warehouse development.
• Expertise in Informatica and data modeling in data warehouse environments.

Responsibilities

• Analyze data in the Enterprise Data Warehouse and develop processes.
• Conduct data analysis, visualization, and quality assessments.

Skills

ETL Processes

Data Warehouse Development

Data Science

Data Modeling

Data Quality Standards

Data Profiling

Data Cleansing

Data Analysis

Tools

Informatica

Oracle

SQL Server

AWS

Erwin

Job description

Overview

Allied Consultants, Inc. is an Austin-based firm which has for 33 years been a premier provider of technical and business professionals to clients in Texas. We are currently seeking an experienced Data Scientist to be a key resource on a technical services team.

Allied Consultants offers its family of consultants excellent rates, a local support staff, and an attractive benefits package which includes medical insurance (Allied shares a percentage of the cost), life insurance, a matching 401(k) plan and a cafeteria plan.

Candidates selected for interview will be required to undergo criminal background checks and may be required to complete a drug screen in accordance with Federal and State Law. Offers of Employment are contingent on a successful background check

Allied Consultants is an equal opportunities employer.

**Location of job: Remote**

Responsibilities

The Worker(s) will provide the following services:

Perform complex Data Scientist work. Analyze information in client’s Enterprise Data Warehouse and design, develop, and test processes for the data warehouse. Develop and document processes to extract data from the data warehouse for accurate reporting. Conduct complex data analysis and visualization tasks along with gathering, determining data quality/profiles, data cleansing, and preparing data from various sources. Perform other analysis and documentation tasks as required to facilitate and support the Enterprise Data Warehouse. Define and document the technical architecture. Provide a written report of assessment methodology, findings, gap analysis, conclusions, and recommendations for a more robust method of reporting data. Communicate with the project stakeholders, management, and other relevant parties to discuss methodology, approach, and schedule. Perform other duties as assigned to maintain operations.

Client to obtain expert services to:

• Assess client’s Workforce Innovation and Opportunities Act (WIOA) customer data contained in client’s Virtual One Stop case management system for potential data quality issues impacting client’s ability to produce WIOA performance data that is consistent, accurate, and reliable, including production of U.S. Department of Labor Participant Individual Record Layout (PIRL) Reports for submission in the Workforce Integrated Performance System (WIPS).
• Assess and evaluate the current analytics model used to create data (files/detail tables), merge data, process and calculate data, and produce outcomes data that reliably supports tracking performance outcomes for WIOA services provided by the State and its twenty-eight (28) Local Workforce Development Boards.
• Provide a written report containing the assessment methodology, findings, conclusions, and recommendations for corrective actions. The report would also include a proposed specific resolution plan that contains specific actionable tasks to implement in order to effectively resolve identified findings.

Qualifications

Minimum Requirements:

• 8 years of design and develop Extraction, Transformation, Load (ETL) processes for enterprise data warehouse using Informatica; Deep hands-on expertise with Informatica ETL processes, development, data management, data profiling, data flows, data relationships, and data quality standards and processes
• 8 years of hands-on experience with data warehouse development and testing (relational and dimensional) and proven evidence to implement using databases like Oracle, SQL Server etc. but preferably Oracle
• 8 years experience in Data Science
• 8 years hands on experience with data modeling preferably in a data warehouse environment
• 8 years experience with Informatica product suite in the Informatica cloud
• 8 experience devising and utilizing algorithms and models to mine data; perform data and error analysis to improve models; clean and validate data for uniformity and accuracy
• 3 years experience with detecting and providing solutions to addressing mismatched data in case management systems

Preferred:

• 5 years or more than one type of RDBMS (DB2, SQL Server, Oracle)
• 5 years of Erwin or other equivalent data modeling tools
• 3 years experience in Amazon Web Services
• 2 years experience with detecting and providing solutions to addressing mismatched data in case management systems