2000 16th Street, Denver, Colorado, 80202, United States of America
Senior ETL Developer, Business Intelligence
EXPERIENCE:
- Proficient in SQL Development.
- Understanding of Data Warehouse best practices and Data Warehousing concepts (Dimensions, Facts tables, surrogate keys, mapping, incremental loads, workflows, etc.).
- Informatica experience (6-12 months of experience minimum).
- Experience with Netezza would be a huge plus.
- Google Cloud experience is a plus (BigQuery, Snowflake).
- Python programming experience is a plus.
- Basic Unix experience needed. Unix scripting is a plus.
- Ability to analyze data, identify complex data patterns.
- Ability to work independently and meet tight deadlines with accurate results.
- Strong communication and team building skills.
- Strong analysis skills required.
- Experience with complex enterprise business applications data discovery, data warehousing and relational database architecture concepts required.
JOB DUTIES:
- Responsible for designs, develops, tests, and documents database architecture, data model and implements ETL/ELT processes for use in data warehouse and business intelligence projects utilizing Informatica, Unix, Oracle, MS SQL and Netezza technologies.
- Design and lead the development of ER models and Database Schema such as Star and Snowflake Schema.
- Design and lead the implementation of application database architecture using various RDBMS platform (Oracle,MS SQL, Netezza).
- Design and lead the development of Packages, Stored Procedures, Triggers, and other PL/SQL and T-SQL programs.
- Design and lead the development of UNIX scripts to support batch processes or data conversion.
- Optimize Queries, Stored Procedures, ETL process, and databases performance.
- Provide quality oversight for all activities related to data cleansing, data quality and data consolidation using standard data modeling methodologies and processes.
- Design and lead the development of ETL processes and Scheduled Jobs to support Data Integration Projects.
- Participate in the creation of User documentation and in providing training to the users.
- Develop and maintain knowledge and up-to-date expertise in evolving technologies.
- Co-ordinate QA and User Acceptance Testing.
- Document test plans.
- Support system implementation and roll-out and provide production support.
EDUCATION & EXPERIENCE:
- The position requires a minimum of a Bachelor’s degree or foreign Degree Equivalent in Computer Science, Computer Engineering or a related field with 5 years of experience in the job or performing similar job duties.
Here is what you can expect when you join our Village:
- A "community first, company second" culture based on Core Values that really matter.
- Clinical outcomes consistently ranked above the national average.
- Award-winning education and training across multiple career paths to help you reach your potential.
- Performance-based rewards based on stellar individual and team contributions.
- A comprehensive benefits package designed to enhance your health, your financial well-being and your future.
- Dedication, above all, to caring for patients suffering from chronic kidney failure across the nation.
About Information Technology
The Information Technology Department designs, develops and maintains software programs required to keep DaVita on the leading edge of medical technology. DaVita’s Information Technology Department has both clinic facing and non-clinic facing subgroups that provide our clinician teammates the tools to provide quality patient care. DaVita IT utilizes designers, developers, system architects, project managers, application architects, nurses, trainers and many more professionals to incorporate the technology needs of our clinicians, business and physician customers.
Join us as we pursue our vision "To Build the Greatest Healthcare Community the World has Ever Seen."
Why wait? Explore a career with DaVita today.
Go to http://careers.davita.com to learn more or apply.
To learn more about our Village and the world of dialysis, click here.
What We’ll Provide:
More than just pay, our DaVita Rewards package connects teammates to what matters most. Teammates are eligible to begin receiving benefits on the first day of the month following or coinciding with one month of continuous employment. Below are some of our benefit offerings.
- Comprehensive benefits: Medical, dental, vision, 401(k) match, paid time off, PTO cash out
- Support for you and your family: Family resources, EAP counseling sessions, access Headspace®, backup child and elder care, maternity/paternity leave and more
- Professional development programs: DaVita offers a variety of programs to help strong performers grow within their career and also offers on-demand virtual leadership and development courses through DaVita’s online training platform StarLearning.
#LI-SM5
At DaVita, we strive to be a community first and a company second. We want all teammates to experience DaVita as "a place where I belong." Our goal is to embed Diversity & Belonging into everything we do in our Village, so that it becomes part of who we are. We are proud to be an equal opportunity workplace and an affirmative action employer. As such, individuals are recruited, hired, assigned and promoted without regard to race, national origin, religion, age, color, sex, sexual orientation, gender identity, disability, protected veteran status, or any other protected characteristic.
Applications are accepted on an ongoing basis.
Salary/ Wage Range
$82,800.00 - $121,600.00 / year
Compensation for the role will depend on a number of factors, including a candidate’s qualifications, skills, competencies and experience and may fall outside of the range shown. DaVita offers a competitive total rewards package, which includes a 401k match, healthcare coverage and a broad range of other benefits. Learn more at https://careers.davita.com/benefits
Colorado Residents: Please do not respond to any questions in this initial application that may seek age-identifying information such as age, date of birth, or dates of school attendance or graduation. You may also redact this information from any materials you submit during the application process. You will not be penalized for redacting or removing this information.