What are the responsibilities and job description for the Data Warehouse Developer position at Motion Recruitment?
Job Description
About the job Would you like to work for one of the nation's leading not-for-profit Medicare Advantage plans, serving more than 270,000 members in California, Arizona, and Nevada. They have been a mission-driven organization dedicated to keeping seniors healthy and independent for more than 40 years and is known throughout the healthcare industry and nationally as a leading expert in senior healthcare. Their employees are a group of talented, passionate professionals who are committed to supporting older adults on their aging journey, while also innovating healthcare for seniors everywhere. Employees are provided in-depth training and access to state-of-the-art tools necessary to do their jobs, as well as development and growth opportunities. They take great pride in recognizing our team members as experts in their fields and rewarding them for their efforts.
The Job Support organizational decision-making by transforming health care operations data into concise and actionable system solutions supporting Business Intelligence activities.
You Will
Demonstrates expertise in the data warehouse/data mart life cycle especially with regards to translating business needs into BI solutions.
Develops and maintains up-to-date knowledge of internal/source information, system modules, structure and data.
Develops ETL code that performs efficiently and accurately.
Creates data cubes that enable end-user access to the data warehouse.
Creates specifications to supply professional report developers a roadmap to building report suites.
Gathers user requirements. Makes presentations to the data warehouse team and participates in group design sessions.
Pursues continuous improvement of data quality, standardization of data management processes, efficiency, and quality of service.
Communicates effectively with clients to identify needs and evaluate alternative business solutions with project management.
Continually seeks opportunities to increase customer satisfaction and deepen client relationships.
Maintains professional and technical knowledge by attending educational workshops, reviewing professional publications, establishing personal networks, and participating in professional societies.
Contributes to team effort by accomplishing related results, as needed.
Actively supports the achievement of Vision and Goals.
Other duties as assigned.
Your Qualifications
Bachelor's Degree in Computer Information Systems or other technology related discipline. A comparable combination of education/experience and/or training will be considered equivalent to the education listed.
4 years professional experience. 3 years of health care experience (preferred).
Understanding of enterprise data warehousing, dimensional modeling and STAR schemas.
In depth SQL development experience with SQL 2017.
Experience with Transactional SQL (T-SQL), SQL Reporting Service (SSRS) and SSIS packages development. Proficient in the Microsoft BI Stack (SSIS, SSRS, SSAS).
Experience Facilitating Data Discovery And Requirements Gathering.
Experience in fine tuning SQL queries and data replication.
Proven understanding of complex database concepts as well as the implications of different database designs.
Possesses significant knowledge of client server and internet systems architectures.
Experience with cloud technologies is desired
Strong interpersonal skills, including excellent written and verbal communication skills.
Strong organizational skills; Ability to multitask.
Ability to appropriately maintain confidentiality.
Strong Analytical And Critical Thinking Skills, Required.
Covid-19 Vaccination Policy
To ensure a healthy and safe work environment, if you are selected for this position, your job offer will be contingent upon being fully vaccinated and providing proof of your COVID-19 vaccine within 3 days after your start date. Generally, you are considered fully vaccinated 14 days after receiving the last dose, as recommended by the manufacturer, of a vaccine that has been authorized by the FDA for use in the United States, including vaccinations that have been approved pursuant to an Emergency Use Authorization. If fully vaccinated outside of the United States, the vaccination must be listed for emergency use by the World Health Organization (WHO). If you cannot receive the vaccine because of a disability/medical reason or sincerely-held religious belief, you may request an accommodation to this requirement by contacting COVID-19 Vaccination Policy. Learn more about the COVID-19 vaccination here -
What's in it for you?
We're always looking for talented people to join our team! Qualified applicants are encouraged to apply now!
The Job Support organizational decision-making by transforming health care operations data into concise and actionable system solutions supporting Business Intelligence activities.
You Will
Demonstrates expertise in the data warehouse/data mart life cycle especially with regards to translating business needs into BI solutions.
Develops and maintains up-to-date knowledge of internal/source information, system modules, structure and data.
Develops ETL code that performs efficiently and accurately.
Creates data cubes that enable end-user access to the data warehouse.
Creates specifications to supply professional report developers a roadmap to building report suites.
Gathers user requirements. Makes presentations to the data warehouse team and participates in group design sessions.
Pursues continuous improvement of data quality, standardization of data management processes, efficiency, and quality of service.
Communicates effectively with clients to identify needs and evaluate alternative business solutions with project management.
Continually seeks opportunities to increase customer satisfaction and deepen client relationships.
Maintains professional and technical knowledge by attending educational workshops, reviewing professional publications, establishing personal networks, and participating in professional societies.
Contributes to team effort by accomplishing related results, as needed.
Actively supports the achievement of Vision and Goals.
Other duties as assigned.
Your Qualifications
Bachelor's Degree in Computer Information Systems or other technology related discipline. A comparable combination of education/experience and/or training will be considered equivalent to the education listed.
4 years professional experience. 3 years of health care experience (preferred).
Understanding of enterprise data warehousing, dimensional modeling and STAR schemas.
In depth SQL development experience with SQL 2017.
Experience with Transactional SQL (T-SQL), SQL Reporting Service (SSRS) and SSIS packages development. Proficient in the Microsoft BI Stack (SSIS, SSRS, SSAS).
Experience Facilitating Data Discovery And Requirements Gathering.
Experience in fine tuning SQL queries and data replication.
Proven understanding of complex database concepts as well as the implications of different database designs.
Possesses significant knowledge of client server and internet systems architectures.
Experience with cloud technologies is desired
Strong interpersonal skills, including excellent written and verbal communication skills.
Strong organizational skills; Ability to multitask.
Ability to appropriately maintain confidentiality.
Strong Analytical And Critical Thinking Skills, Required.
Covid-19 Vaccination Policy
To ensure a healthy and safe work environment, if you are selected for this position, your job offer will be contingent upon being fully vaccinated and providing proof of your COVID-19 vaccine within 3 days after your start date. Generally, you are considered fully vaccinated 14 days after receiving the last dose, as recommended by the manufacturer, of a vaccine that has been authorized by the FDA for use in the United States, including vaccinations that have been approved pursuant to an Emergency Use Authorization. If fully vaccinated outside of the United States, the vaccination must be listed for emergency use by the World Health Organization (WHO). If you cannot receive the vaccine because of a disability/medical reason or sincerely-held religious belief, you may request an accommodation to this requirement by contacting COVID-19 Vaccination Policy. Learn more about the COVID-19 vaccination here -
What's in it for you?
- A competitive compensation and benefits program
- An annual employee bonus program
- Robust Wellness Program
- Generous paid-time-off (PTO)
- Ten paid holidays per year, plus 1 additional floating holiday
- Excellent 401(k) Retirement Saving Plan with employer match
- Robust employee recognition program
- Tuition reimbursement
- An opportunity to become part of a team that makes a difference to our members and our community every day!
We're always looking for talented people to join our team! Qualified applicants are encouraged to apply now!
Sales associate
Ascent Developer Solutions -
Los Angeles, CA
VP, Sales Manager (Commercial Real Estate)
Ascent Developer Solutions -
Los Angeles, CA
Senior Vice President, Credit
Ascent Developer Solutions -
Los Angeles, CA
