Principal Data Engineer Lead

Blue Cross and Blue Shield of Minnesota
Eagan, United States of America
2 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior
Compensation
$ 159K

Job location

Remote
Eagan, United States of America

Tech stack

Amazon Web Services (AWS)
Data analysis
Automation of Tests
Big Data
Unix
Software Documentation
Code Review
Data Architecture
Data Integration
ETL
Data Systems
Data Warehousing
Software Design Documents
Dimensional Modeling
Human-Computer Interaction
Metadata
Performance Tuning
Shell Script
Software Deployment
Software Requirements Analysis
SQL Databases
Technical Data Management Systems
Teradata
Test Case Design
Enterprise Data Management
Data Strategy
Data Analytics
Data Management

Job description

At Blue Cross and Blue Shield of Minnesota, we are committed to paving the way for everyone to achieve their healthiest life. Blue Cross of Minnesota is an Equal Opportunity Employer and maintains an Affirmative Action plan, as required by Minnesota law applicable to state contractors. All qualified applications will receive consideration for employment without regard to, and will not be discriminated against based on any legally protected characteristic., At Blue Cross and Blue Shield of Minnesota, we are committed to paving the way for everyone to achieve their healthiest life. We are looking for dedicated and motivated individuals who share our vision of transforming healthcare. As a Blue Cross associate, you are joining a culture that is built on values of succeeding together, finding a better way, and doing the right thing. If you are ready to make a difference, join us.

The Impact You Will Have

This position is responsible for providing technical and resource leadership for enabling data analytics which includes leading or executing user story development, data design and architecture, data integration development, testing or BI application delivery in the BCBSMN data warehouse framework including surrounding enablement environments. The lead principal position will collaborate and/or partner with business areas, project teams, IT technical teams, as well as outsourced vendors to ensure high quality delivery of data architecture and data integration applications focusing innovation and creativity enabling value add to the business on large scale efforts.

Your Responsibilities

  • As a technical expert, leads creation and review highly complex data solutions enforcing best practices, processes and standards for user story development, data analysis, architecture, modeling, design, coding, testing, deployment and scheduling.
  • Advocates for the broad education and understanding of the corporate data strategy within the department and enterprise including varying levels of leadership within the organization as needed seeking collaborative opportunities as appropriate.
  • Collaborates and partners with project and resource managers in developing scope, dependencies, estimates, project plans, schedules, status reporting, and issue/risk management.
  • Accountable for establishing and maintaining effective and positive relationships with internal and external customers, as well as the development of strategic relationships outside of the organization.
  • Leads or oversees the execution of the data management lifecycle to enable business data analytics motivating and inspiring others to exceed goals.
  • Performing lead functions (e.g,. providing work direction, monitoring work, providing feedback, coaching/mentoring as needed).
  • Specialty Business Intelligence - As the technical expert in business analytical enablement, develop or lead user story development, design, documentation and/or development of the user interface, data integration/prep, analysis, metadata, development and testing of reports or BI Solutions identifying further opportunities aligned with strategic goals.
  • Design and develop prototypes or final data/BI solutions to enable the measurement or monitoring of key performance indicators.
  • Data Designer/Architect - As the technical expert, lead or assists in the development, documentation, and maintenance of the enterprise data architecture and its deliverables including the design principles, standards and models for transactional and analytical systems serving both strategic and tactical needs.
  • Mentors, educates and leads others in data architecture deliverables through the project development life cycle or support effort while ensuring quality and compliancy to the enterprise data strategy.
  • Data Integration Developer - As a technical expert in ETL/ELT and data integration development designs, develops, tests complex data integration platform in compliancy with standards and industry best practices.
  • Responsible for identifying and/or making significant improvement enhancements to existing artifacts to align with enterprise strategy or to improve user experience.
  • Test Engineer - As a technical expert in data system quality, accountable for the creation and/or review of test documentation for data deliverables including but not limited to test approach, test plans, test schedule, test case and test result documentation.
  • Ensure test environment and data readiness is appropriate for support and project deliverables.
  • Accountable for complex test cases in interdependent enterprise systems based on system requirements and technical design documentation, using automation to the fullest extent.
  • Execution and maintenance of manual and/or automated test cases and scripts, as assigned.
  • Analyzes test results and documents defects and issues using the Incident Management Process.

Requirements

  • 7+ years of related professional experience. All relevant experience including work, education, transferable skills, and military experience will be considered.
  • Extensive experience developing complex data integration solutions using two or more of data management software tools.
  • Extensive knowledge and experiences in data analysis using complex SQL, user story development, data warehouse design and modeling (3rd normal form and dimensional modeling), data integration design and development and/or performance tuning Teradata SQL.
  • Extensive knowledge in data warehouse market best practices, development standards and methodologies.
  • Demonstrated ability and willingness to play multiple roles for different projects, e.g., planning/architecting and overseeing development for some projects, being a hands-on technical resource for others.
  • Not only leading and working on strategic and tactical projects, but also understand the importance of details and remaining hands-on to data applications/solution business enablement.
  • Highly experienced in work estimation, design review and code review and complete BI solution design.
  • Excellent skills in coordination with multiple teams for project execution and issue resolution, as well as working with contracting vendor onsite and offshore.
  • Demonstrated oral/written communication and presentation skills to effectively communicate complex technical information while inspiring and motivating others.
  • Demonstrated ability to independently influence, motivate and lead teams with diverse professional backgrounds.
  • Experienced in mentoring and coaching junior developers in problem solving and critical thinking efforts.
  • High school diploma (or equivalency) and legal authorization to work in the U.S

Preferred Skills and Experience

  • Bachelor's degree
  • Practical and relevant experience with two or more data warehouse and big data technical tools
  • Experience with storage, ETL/ELT processes and orchestration with AWS Cloud Technologies
  • Teradata, Informatica, Wherescape Red, Power experience with Agile/Scrum project methodology
  • Knowledge of the health care/health insurance industry
  • Working knowledge of UNIX environment including shell scripting and scheduler (ideally StoneBranch)

Benefits & conditions

Our hybrid approach is designed to balance flexibility with meaningful in-person connection and collaboration. We come together in the office two days each week - most teams designate at least one anchor day to ensure team interaction. These in-person moments foster relationships, creativity, and alignment. The rest of the week you are empowered to work remote.

Compensation and Benefits:

Pay Range: $117,800.00 - $159,000.00 - $200,200.00 Annual

Pay is based on several factors which vary based on position, including skills, ability, and knowledge the selected individual is bringing to the specific job.

We offer a comprehensive benefits package which may include:

  • Medical, dental, and vision insurance
  • Life insurance
  • 401k
  • Paid Time Off (PTO)
  • Volunteer Paid Time Off (VPTO)
  • And more, $117.00

Apply for this position