BI Analyst / Developer (Remote - Part Time)

Job Title: BI Analyst / Developer (Remote - Part Time) Location: Salem, OR Duration: 12 months Pay Rate: $80/hr on C2C / 1099 all inclusive (OR) $75/hr on W2 Note: The contract will begin with full-time hours in July and possibly August 2026 and will shift to part-time thereafter until the end date or 1,040 hour limit is reached. The contract may not exceed 1,040 total hours. This position is approved for remote work. Remote onboarding will be required for the first day.

Job Description

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. 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 that may assist businesses in developing a solid BI strategy Tasks: Contractor’s Key Person shall

• 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 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.

Required skills and experience:

• 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: 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 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. Top Skills & Years of Experience Skill Matrix: Skills Database Data Analysis Proficient (4-6 Years) Yes Skills Database Data Warehousing Proficient (4-6 Years) No Skills Database Microsoft SQL Server Advanced (7-9 Years) Yes Skills Languages SQL Advanced (7-9 Years) Yes Skills Others Python Advanced (7-9 Years) Yes Skills Others SAS Advanced (7-9 Years) No Skills Others Communication skills both verbal and written Proficient (4-6 Years) Yes Skills Tools MicrosoftOffice Proficient (4-6 Years) Yes Recruiter Details: Name : Lokesh Contact : Eight three two - Nine nine zero -Two four two six About US: GSK Solutions Inc. is a premier information technology services company dedicated to delivering exceptional consulting solutions and staff augmentation to our valued clients. With an unwavering commitment to quality, timeliness, and budgetary considerations, we consistently strive to exceed client expectations, building a strong reputation through our reliable execution. Our expertise spans commercial and custom product development, covering information security, software development, consulting, and IT audits. We excel in managing critical, time-sensitive projects for Fortune 500 clients nationwide, ensuring their success is always at the forefront of our mission Apply tot his job Apply To this Job