Data Engineer (SQLPython ETL Modernization)
Job Location:
Monthly Salary:
Posted on:
4 days ago
Posted on:
Vacancies:
1 Vacancy
Vacancies:
Job Summary
Title: Data Engineer (SQL/Python ETL Modernization)
Location: Salem OR - REMOTE
Duration: 6 Months
Description:
Extraction and analysis of company information primarily financial personal expense and revenue reports. Writing data collection and processing procedures. Ensuring that data is being correctly gathered stored and analyzed. Reporting data findings to management. Continually monitor data collection. Develop methodologies to improve data analysis. Bachelors degree in finance math or data science. Hands-on knowledge of database tools SQL. Knowledge of programming languages like Python Java and R. Excel Agile Data modeling Data analytics Data mining Data visualization. Familiarity with analytical tools like SAS Hadoop Spark Hive and Pig that may assist businesses in developing a solid BI strategy
Qualifications:
Bachelors degree in finance math or data science. Hands-on knowledge of database tools SQL. Knowledge of programming languages like Python Java and R. Excel Agile Data modeling Data analytics Data mining Data visualization. Familiarity with analytical tools like SAS Hadoop Spark Hive and Pig that may assist businesses in developing a solid BI strategy
Duties and Responsibilities:
Extraction and analysis of company information primarily financial personal expense and revenue reports. Writing data collection and processing procedures. Ensuring that data is being correctly gathered stored and analyzed. Reporting data findings to management. Continually monitor data collection. Develop methodologies to improve data analysis.
Email your resume to:
To learn more about Mavensoft visit us online athttp://
Location: Salem OR - REMOTE
Duration: 6 Months
Description:
Extraction and analysis of company information primarily financial personal expense and revenue reports. Writing data collection and processing procedures. Ensuring that data is being correctly gathered stored and analyzed. Reporting data findings to management. Continually monitor data collection. Develop methodologies to improve data analysis. Bachelors degree in finance math or data science. Hands-on knowledge of database tools SQL. Knowledge of programming languages like Python Java and R. Excel Agile Data modeling Data analytics Data mining Data visualization. Familiarity with analytical tools like SAS Hadoop Spark Hive and Pig that may assist businesses in developing a solid BI strategy
- Perform analysis of HAL data system as needed which may include reviewing documentation and analyzing current HAL system/ environment including data models schemas and tables data dictionaries ETLs system and database management processes data quality security queries reporting environment.
- Work with OHA project team members (PM BAs DBAs data analysts architects) HAL management and HAL users to identify/ determine business/technical requirements.
- Gather and document detailed system data and integration requirements for HAL system improvements (e.g. changes to ETL code business rules HAL tables new or updated OHG Medicaid claim code grouping categories etc.)
- Design develop and implement data pipelines using ETL processes and SQL tables that extract transform and load data into a HAL Medicaid data system/ datamart that helps the organization reach its strategic goals.
- Migrate existing ETL process built in legacy SAS coding to Microsoft Structured Query Language (SQL) stack and Python language/ stored procedures by:
- Working with various program areas and business teams to make code as modular as possible.
- Reviewing and analyzing existing ETL SAS programming code to update to new SQL/ Python language/ procedures
- Developing new SQL stack / stored procedures programming code to create new ETL processes.
- Test troubleshoot and implement the new ETL code in the HAL test and production environments.
- SQL programming language
- Python programming language
- Advanced data analysis skills.
- Experience using Microsoft DevOps GIT or other code management tools.
- In addition the ideal candidate will have skills and experience in:
- SAS programming language
- Experience using Jupyter Notebooks
- Data Warehousing
- Good communication skills
Qualifications:
Bachelors degree in finance math or data science. Hands-on knowledge of database tools SQL. Knowledge of programming languages like Python Java and R. Excel Agile Data modeling Data analytics Data mining Data visualization. Familiarity with analytical tools like SAS Hadoop Spark Hive and Pig that may assist businesses in developing a solid BI strategy
Duties and Responsibilities:
Extraction and analysis of company information primarily financial personal expense and revenue reports. Writing data collection and processing procedures. Ensuring that data is being correctly gathered stored and analyzed. Reporting data findings to management. Continually monitor data collection. Develop methodologies to improve data analysis.
Email your resume to:
To learn more about Mavensoft visit us online athttp://
Required Experience:
IC
About Company
Advance Your Business Goals Through Valuable IT Solutions Command Your Market Share Through Digital Transformation Advance Your Career at Mavensoft...Read More
