Data Solutions Engineer I or II

Blue Cross of Idaho • Meridian, ID

9d • Hybrid

About The Position

Our Data Solutions Engineers assist in leading the design, development, implementation, documentation and support of data operations solutions. Provide technical management and consulting for business users and IT professionals on the design, development and utilization of data-related tools, technologies, and processes. This person will research, implement, engineer, configure, monitor, manage, patch and troubleshoot software systems, applications, technologies and/or the technical infrastructure. Location: this position is based in a hybrid work environment (combination of onsite work at the Meridian, Idaho campus and work-from-home).

Requirements

• Bachelor's degree in Computer Science, Information Systems, or closely related field of study; or equivalent practical work experience (two years’ relevant work experience is equivalent to one-year college).
• 2/+ years’ design or development of software applications, databases, systems, technology infrastructure, or related experience.
• Knowledge and skills should also span one or both of: Data Engineering & ETL/ELT: Designing data warehouses and pipelines using SQL.
• C# & .NET Application Development: Building backend applications and APIs using C# and .NET Core.
• Database & Query Performance Tuning: Optimizing database schemas, indexing, and complex SQL queries for speed.
• DevOps, CI/CD & Pipeline Automation: Setting up automated deployment workflows and orchestrating system dependencies.
• Testing, Quality Assurance & Monitoring: Creating automated validation checks, unit tests, and performance monitoring.

Nice To Haves

• Experience with Wherescape RED, SSIS, Snowflake, and/or DBT

Responsibilities

• Participate in full development lifecycle including requirements analysis and design.
• Translate business requirements into technical requirements during refinement.
• Write technical specifications based on conceptual design and stated business requirements.
• Profile source data systems to map schemas, identify data types, and define source-to-target mapping logic.
• Design and configure source connections and staging areas.
• Orchestrate high-performance data extraction from relational databases, APIs, and flat files.
• Execute fast bulk loading into target data warehouses
• Implement incremental loading logic using Change Data Capture (CDC) or Delta tracking.
• Develop and optimize in-database transformations (ELT) using T-SQL stored procedures.
• Automate software deployment processes and develop automation tools.
• Ensure the integrity of the builds and artifacts.
• Develop tools and/or scripts to support and improve current software, systems, or technology builds and release process and continuous integration, and delivery initiatives.
• Configure orchestration workflows and dependency trees.
• Implement test plans, automation, and validation strategies.
• Create test processes and procedures used to ensure that software operates within defined requirements.
• Develop and maintain automated test scripts to reduce repetitive manual testing.
• Build automated data reconciliation checks to validate row counts, check for nulls, and ensure data integrity between source and target.
• Support, maintain, and document software functionality.
• Create, troubleshoot and maintain written procedures.
• Analyze code to find causes of errors and revise programs.
• Configure robust error handling, event logging, and email alerts for failed pipeline tasks.
• Monitor application performance by anticipating and correcting operational issues before occurrence.
• May review solution performance and continually assess health of software, systems, and/or technologies.
• Track and drive awareness to operational and technical risks.
• Tune ELT performance by rebuilding database indexes, updating statistics, and optimizing SQL execution plans.
• Maintain data lineage metadata and data warehouse documentation.

Benefits

• paid time off
• paid holidays
• community service and self-care days
• medical/dental/vision/pharmacy insurance
• 401(k) matching and non-contributory plan
• life insurance
• short and long term disability
• education reimbursement
• employee assistance plan (EAP)
• adoption assistance program
• paid family leave program

What This Job Offers

• Job Type: Full-time
• Career Level: Entry Level