Job Title: BI Programmer
Location: Portland OR
Duration: 1040 Hours
Rate: $70/hr. on C2C All Inclusive
Responsibilities:
Programming, testing and delivering other programming enhancements or programming work items related to architecture, dataflows, tables, views, queries, reports, and ETL logic, including:
Gather and document detailed system, data and integration requirements for system improvements (e.g. changes to ETL code, business rules, HAL tables, new or updated 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 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.
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
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
- Dice Id: 10265865
- Position Id: OOJ - 1733-734-1780591238
- Posted 21 hours ago
Never miss an opportunity! Create an alert based on the job you applied for.
