What are the responsibilities and job description for the Senior Data Warehouse ETL Developer position at Impresiv Health?

Job Title : Senior Data Warehouse ETL Developer

Location : Hybrid, must live in or around Fairfield, CA

Job Type : Full-time, ASAP Start

Salary Range : $136,296.78 - $177,185.82 / year

Description :

Responsible for the development of all processes necessary to complete all phases of the

Enterprise Data Warehouse (EDW). This includes source identification, data collection, data

transformation, normalization, rule administration, error detection and correction, data

consolidation, data storage, data distribution, schema mapping, data enrichment, and data

governance.

What You Will Do :

Essential Duties and Responsibilities
Lead ETL resource on new ETL development for the Data Warehouse.
Responsible for the entire flow of the data into the Data Warehouse.
Develops and maintains in-depth understanding of SQL Server, Oracle, BusinessObjects,

Access databases, and Analysis Services.

Responsible for developing SSIS packages used in the Extract, Transform, and Load

ETL) processes for EDW.

Provides guidance for all Master Data Management (MDM) aspects involved in the

development of the EDW.

Responsible for understanding all development in the area of MDM and ETL.

Responsible for the transition of documentation, security, development, and testing of all

procedures in the EDW.

Responsible for coordination with other departments regarding consistency and accuracy

of data.

Works with Web Team on development and coordination of ETL and other processes.

Uses sound technical judgment and makes appropriate systems decisions in absence of

the Associate Director, Data Warehouse and Architecture.

Responsible to train new staff on ETL architecture, ETL standards, and ETL

documentation.

Responsible for the coordination of the production, development, and sandbox

environments.

Designs, develops, tests, and supports client server applications using C# and ASP.NET

Experience in working with .NET Web Services, WCF framework and Web API using

WSDL, SOAP and UDDI

Performs other tasks necessary to ensure integrity of eCommerce / AMYSIS databases

and the accuracy of reporting data.

Leads and participates in special projects as needed and assigned.

You Will Be Successful If :

Ability to quickly acquire in-depth knowledge of new systems and

software configuration at PHC.

Strong written and oral communication skills with ability to interpret and understand technical requirements.

Excellent analytical skills to troubleshoot and resolve systems problems.

Able to develop procedures to automate jobs and to document extensively and clearly.

Good client relations skills.

Provide the highest possible level of service to clients.

Promote teamwork and cooperative effort among employees.

Maintain safe practices; and

Abide by the HealthPlan's policies and procedures, as they may from time to time be updated.

What You Will Bring :

Bachelor's degree in Computer Science, Business, or related field.

Minimum four (4) years of systems analysis experience with

experience in medical information systems or equivalent combination

of education and experience.

Experience with healthcare data is

preferred.

Knowledge of databases (SQL Server, BusinessObjects, Access, SSIS,

normalization, queries, views).

Knowledge of QlikView and Qlik Sense.

Some knowledge of Oracle and Oracle programming methodologies.

Knowledge of data warehousing, data marts, OLAP, ROLAP, MOLAP, etc.

Ability to move data between systems as needed, effortlessly.

High standards for data presentation.

Significant knowledge of PCs, Windows 2000, and related applications.

Understanding of systems and related systems interfaces and how changes impact various systems.

About Impresiv Health :

Impresiv Health is a healthcare consulting partner specializing in clinical & operations management, enterprise project management, professional services, and software consulting services. We help our clients increase operational efficiency by delivering innovative solutions to solve their most complex business challenges.

Our approach is and has always been simple. First, think and act like the customers who need us, and most importantly, deliver what larger organizations cannot do – provide tangible results that add immediate value, at a rate that cannot be beaten. Your success matters, and we know it.

That's Impresiv!

Salary : $136,297 - $177,186

Apply for this job

Receive alerts for other Senior Data Warehouse ETL Developer job openings

Senior Data Warehouse ETL Developer

What are the responsibilities and job description for the Senior Data Warehouse ETL Developer position at Impresiv Health?

What is the career path for a Senior Data Warehouse ETL Developer?

Job openings at Impresiv Health

Not the job you're looking for? Here are some other Senior Data Warehouse ETL Developer jobs in the Fairfield, CA area that may be a better fit.

We don't have any other Senior Data Warehouse ETL Developer jobs in the Fairfield, CA area right now.

AI Assistant is available now!