Business Information Developer Consultant Senior

• Undertakes complex assignments requiring additional specialized technical knowledge.
  
• Develops very complex and varied strategic report applications from a Data Warehouse.
  
• Establishes and communicates common goal and direction for team.
  
• Establishes and maintains advanced knowledge of data warehouse database design, data definitions, system capabilities, and data integrity issues.
  
• Acts as a source of direction, training, and guidance for less experienced staff.
  
• Monitors project schedules and costs for own and other projects.
  
• Develops and supports very complex Data Warehouse-related applications for business areas requiring design and implementation of database tables.
  
• Conducts training on use of applications developed.
  
• Spends time thinking about programming and how it would be used to design solutions.
  

• Strong experience in Data Engineering, ETL development, and enterprise data integration highly preferred.
  
• Hands-on experience with Informatica PowerCenter for designing, developing, and maintaining ETL workflows highly preferred.
  
• Strong proficiency in MS SQL Server with advanced T-SQL/SQL programming, including stored procedures, functions, views, query optimization, and performance tuning highly preferred.
  
• Experience writing SQL/PL/SQL scripts for data extraction, transformation, and validation highly preferred.
  
• Strong understanding of Data Modeling concepts, including logical, physical, and dimensional data models highly preferred.
  
• Experience working with enterprise Data Warehouse (EDW) environments and large-scale data integration solutions highly preferred.
  
• Hands-on experience with one or more enterprise databases, including: MS SQL Server, Snowflake, Oracle, Teradata, Sybase highly preferred.
  
• Experience developing and maintaining Shell Scripts to support ETL processes and data operations highly preferred.
  
• Experience with Control-M for job scheduling, workflow automation, and batch process monitoring highly preferred.
  
• Experience using GitHub or other version control systems for source code management and collaborative development highly preferred.
  
• Strong analytical, troubleshooting, and performance tuning skills for ETL processes and database workloads highly preferred.
  
• Experience with Snowflake data warehouse design, optimization, and cloud data migration highly preferred.
  
• Knowledge of data warehousing concepts, including Star and Snowflake schema design highly preferred.
  
• Strong data analysis and data validation skills highly preferred.
  
• Experience working in Agile/Scrum development environments highly preferred.
  
• Excellent problem-solving, communication, and collaboration skills highly preferred.
  

Please be advised that Elevance Health only accepts resumes for compensation from agencies that have a signed agreement with Elevance Health. Any unsolicited resumes, including those submitted to hiring managers, are deemed to be the property of Elevance Health.

Who We Are

Elevance Health is a health company dedicated to improving lives and communities - and making healthcare simpler. We are a Fortune 25 company with a longstanding history in the healthcare industry, looking for leaders at all levels of the organization who are passionate about making an impact on our members and the communities we serve.

How We Work

At Elevance Health, we are creating a culture that is designed to advance our strategy but will also lead to personal and professional growth for our associates. Our values and behaviors are the root of our culture. They are how we achieve our strategy, power our business outcomes and drive our shared success - for our consumers, our associates, our communities and our business.

We offer a range of market-competitive total rewards that include merit increases, paid holidays, Paid Time Off, and incentive bonus programs (unless covered by a collective bargaining agreement), medical, dental, vision, short and long term disability benefits, 401(k) +match, stock purchase plan, life insurance, wellness programs and financial education resources, to name a few.

Elevance Health operates in a Hybrid Workforce Strategy. Unless specified as primarily virtual by the hiring manager, associates are required to work at an Elevance Health location at least once per week, and potentially several times per week. Specific requirements and expectations for time onsite will be discussed as part of the hiring process.

The health of our associates and communities is a top priority for Elevance Health. We require all new candidates in certain patient/member-facing roles to become vaccinated against COVID-19 and Influenza. If you are not vaccinated, your offer will be rescinded unless you provide an acceptable explanation. Elevance Health will also follow all relevant federal, state and local laws.

Elevance Health is an Equal Employment Opportunity employer and all qualified applicants will receive consideration for employment without regard to age, citizenship status, color, creed, disability, ethnicity, genetic information, gender (including gender identity and gender expression), marital status, national origin, race, religion, sex, sexual orientation, veteran status or any other status or condition protected by applicable federal, state, or local laws. Applicants who require accommodation to participate in the job application process may contact [email protected] for assistance. Qualified applicants with arrest or conviction records will be considered for employment in accordance with all federal, state, and local laws, including, but not limited to, the Los Angeles County Fair Chance Ordinance and the California Fair Chance Act