Data Solutions Engineer I or II

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).

Required Education: 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).

Required Experience: 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.

And:

• 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.

Preferred:

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

As a Data Solutions Engineer you may:

• 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.

As of the date of this posting, a good faith estimate of the current pay range is $78,064 to $117,095 as Engineer I; $96,186 to $1144,275 as Engineer II. The position is eligible for an annual incentive bonus (variable depending on company and employee performance). The pay range for this position takes into account a wide range of factors including, but not limited to, specific competencies, relevant education, qualifications, certifications, relevant experience, skills, seniority, performance, travel requirements, internal equity, business or organizational needs, and alignment with market data. At Blue Cross of Idaho, it is not typical for an individual to be hired at or near the top range for the position. Compensation decisions are dependent on factors and circumstances at the time of offer.

We offer a robust package of benefits including 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 and paid family leave program.

We will adhere to all relevant state and local laws concerning employee leave benefits, in line with our plans and policies.

Reasonable accommodations

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed above are representative of the knowledge, skill and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

We are an Equal Opportunity Employer and do not discriminate against any employee or applicant for employment because of race, color, sex, age, national origin, religion, sexual orientation, gender identity, status as a veteran, and basis of disability or any other federal, state or local protected class.