Business Intelligence Analyst/Developer

V-Soft Consulting Group, Inc. is a leading staffing company recognized for its innovative technology services. They are currently seeking a Business Intelligence Analyst/Developer to design, develop, and implement data pipelines and ETL processes, while collaborating with various teams to improve the HAL Medicaid data system.

Responsibilities:

• 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
• 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, ETL’s, system and database management processes, data quality, security, queries, reporting environment
• Work with 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 Medicaid claim code grouping categories, etc.)

Requirements:

• Bachelor's 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
• SQL programming language
• Python programming language
• Advanced data analysis skills
• Experience using Microsoft DevOps, GIT or other code management tools
• SAS programming language
• Experience using Jupyter Notebooks
• Data Warehousing
• Good communication skills