Programmer Analyst
Programmer Analyst
Posted on :
09-08-2023
Employer Active
The job posting is outdated and position may be filled
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Share
Send me jobs like this
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Jobs by Experience
5years
Monthly Salary
Not Disclosed
Salary Not Disclosed
Posted on :
09-08-2023
Job Description
This is a remote position.
ABOUT ELLIT GROUPS
Ellit Groups is a woman, minority owned, "World-class" Healthcare Information Technology consulting services firm certified by WBENC. We are a team of seasoned operational leaders who have been responsible for some of the largest, most complex EMR implementations in integrated healthcare delivery networks. We believe quality relies on talent and culture. Our Ellit teams deliver our brand promise Your success is our success!
JOB SUMMARY
JOB SUMMARY
The Analyst is responsible defining business intelligence requirements for individual subject areas; develops conceptual data models, design, build, and test sets of reporting and analytic business intelligence programs. Works cross-functionally to collect data and makes actionable recommendations at all levels. Infers trends from a variety of data sources and confidently delivers their interpretation; makes recommendations to management.
Requirements
- Recent ETL/SSIS experience, with some exposure to Epic, and with the ability to analyze many different data issues with minimal supervision.
- 4+ years of experience in data warehouse maintenance and development, including advanced capabilities using SSMS, T-SQL, and SSIS. Able to analyze and create detailed SQL code, and to use MS tools available to ensure solid query performance.
- Comfortable with extremely complex development projects. Able to implement in and/or infer from code bases complicated business rules with multiple layers of processing and multiple output formats. Solid knowledge of star schema output and dimensional modelling, fact table loading, data staging, backout and deduping processes. Experience with multiple file formats and use of SSIS to accommodate imports of those source types.
- Experience within a Healthcare setting.
Desired Experience:
- Strong skills in run support for multiple large and complex datasets, primarily focused on Clinical data, including Pharmacy claims and Lab tests/results. Ability to support entire DW job structure regardless of subject matter expertise, monitor jobs, and to trouble shoot job errors or warnings when needed.
- Experience with Epic Caboodle/Clarity, especially the ability to reengineer processes/interfaces to pull directly from these applications, is highly desirable.
- Experience with cloud platforms, such as Snowflake/Matillion, especially the ability to map existing code sets to new platforms and re-engineer processes to maximize benefit of the new technologies, is highly desirable.
- Experience with data virtualization platforms, such as Denodo, is also desirable.
Benefits
Benefits
Ellit Groups provides comprehensive benefits options to salaried employees, including:
- Medical, Vision, and Dental Insurance
- STD, LTD, and AD&D
- Medical and Dependent Care FSA
- 401k Retirement
- 6 Paid Holidays and Flexible Paid Time Off
To protect the health and safety of our workforce, clients, patients, and communities we serve, Ellit Groups requires all employees to disclose COVID-19 vaccination status prior to beginning employment. In addition, some clients require full COVID-19 vaccination, including boosters, as an essential job function. Ellit Groups adheres to all federal, state, and local COVID-19 vaccination regulations as well as all client COVID-19 vaccination requirements and will obtain the necessary documentation from candidates to ensure compliance.
Ellit Groups is proud to be an equal opportunity and affirmative action employer committed to fostering an inclusive environment. We do not discriminate based upon race, religion, color, national origin, age, sex, sexual orientation, gender, gender identity, Veteran status, disability, any other characteristic protected by local, state or federal laws, rules or regulations. We are committed to providing reasonable accommodation for disabilities or special needs. If you have a disability or special need that requires accommodation, please contact us at .
Recent ETL/SSIS experience, with some exposure to Epic, and with the ability to analyze many different data issues with minimal supervision. 4+ years of experience in data warehouse maintenance and development, including advanced capabilities using SSMS, T-SQL, and SSIS. Able to analyze and create detailed SQL code, and to use MS tools available to ensure solid query performance. Comfortable with extremely complex development projects. Able to implement in and/or infer from code bases complicated business rules with multiple layers of processing and multiple output formats. Solid knowledge of star schema output and dimensional modelling, fact table loading, data staging, backout and deduping processes. Experience with multiple file formats and use of SSIS to accommodate imports of those source types. Experience within a Healthcare setting. Desired Experience: Strong skills in run support for multiple large and complex datasets, primarily focused on Clinical data, including Pharmacy claims and Lab tests/results. Ability to support entire DW job structure regardless of subject matter expertise, monitor jobs, and to trouble shoot job errors or warnings when needed. Experience with Epic Caboodle/Clarity, especially the ability to reengineer processes/interfaces to pull directly from these applications, is highly desirable. Experience with cloud platforms, such as Snowflake/Matillion, especially the ability to map existing code sets to new platforms and re-engineer processes to maximize benefit of the new technologies, is highly desirable. Experience with data virtualization platforms, such as Denodo, is also desirable.
Employment Type
Full Time
Key Skills
Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.
