Business Intelligence Data Engineer IV

Business Intelligence Data Engineer IV

Posted Today by 1765348218

Negotiable
Outside
Remote
USA

Summary: The Business Intelligence Data Engineer IV is an advanced-level role focused on architecting, designing, and implementing Business Intelligence data solutions, including data warehouses and data marts. This position requires extensive experience in data warehouse analysis and design, as well as leadership in complex distributed data systems and DevOps practices. The role also involves mentoring team members and influencing technical direction within the organization. Candidates must have a strong background in the healthcare payer industry and relevant technical skills.

Key Responsibilities:

  • Architect, design, and implement Business Intelligence data solutions, including data warehouses and data marts.
  • Lead the design and implementation of complex distributed data systems and streaming integrations.
  • Champion DevOps practices, ensuring governance, security, and scalability.
  • Mentor team members and influence strategic technical direction.
  • Develop new information marts and enhance existing data solutions.
  • Create normalized and dimensional data models to support reporting and analytics.
  • Design and modify database tables, indexes, constraints, and stored procedures.
  • Develop implementation plans for building target data architecture incrementally.
  • Communicate effectively with stakeholders and team members.

Key Skills:

  • Bachelor's degree required.
  • 10+ years of experience in database programming within a medium to large organization.
  • Experience in strategic data architecture and aligning engineering practices with enterprise data strategy.
  • Healthcare payer industry experience required.
  • Proficiency with Delta Lake, Data Lakehouse, and DevOps practices.
  • Full understanding of SQL and ability to create complex SQL statements.
  • Experience with SQL-related products, including SSIS packages and RDLC solutions.
  • Ability to design and develop logical and physical architectural data diagrams.
  • Excellent communication skills.

Salary (Rate): undetermined

City: undetermined

Country: USA

Working Arrangements: remote

IR35 Status: outside IR35

Seniority Level: undetermined

Industry: IT

Detailed Description From Employer:

Hi,

Greetings from Compsciprep!!!

We have an immediate opening for a position with one of our prestigious clients that may interest you.

Below is the job description for your reference. If you feel that you are a good match for the position, please send us your resume.
Title: Business Intelligence Data Engineer IV
Location: Remote (Candidate must reside in the PST/MST time zone)
Duration: 6+ Months

Interview process: 2 rounds of MS Teams Video
Position Summary
The BI Data Engineer IV is an advanced-level role responsible for architecting, designing, and implementing Business Intelligence (BI) data solutions, including data warehouses, data marts, and info-marts, while ensuring high levels of availability. This position leverages extensive experience in data warehouse analysis and design to develop new information marts and enhance existing data solutions.

The BI Data Engineer IV leads the design and implementation of complex distributed data systems, streaming integrations, and structured storage solutions (e.g., Delta Lake, Data Lakehouse). The role also champions DevOps practices (infrastructure as code, GitOps), ensuring governance, security, and scalability. Additionally, this position involves mentoring team members and influencing strategic technical direction.
Requirements
Education & Experience

  • Bachelor s degree required.
  • 10+ years of progressive experience in database programming within a medium to large organization with a structured IT department.
  • Experience shaping strategic data architecture, building cross-functional consensus, and aligning engineering practices with enterprise data strategy.
  • Healthcare payer industry experience is required.
  • Experience with Delta Lake, Data Lakehouse, DevOps practices (infrastructure as code, GitOps)
  • Full understanding of SQL with the ability to create complex SQL statements across various data structures.
  • Design, develop, implement, and support SQL-related products, including SSIS packages, Agent jobs, RDLC solutions, and other related solutions.
  • Lead the creation of normalized and dimensional data models (logical and physical) to support reporting, analytics, and data integration.
  • Design, create, and modify database tables, indexes, constraints, links, stored procedures, and functions.
  • Develop implementation plans for incrementally building the target data architecture.
  • Develop logical and physical architectural data diagrams.
  • Excellent communication skills


    Thanks and Regards

    Hemanth (Talent Acquisition)

    Cell no:

    CompSciPrep LLC

    Email: