Search Jobs | Dice.com

Job Details

Skills

data engineer
snowflake
migration

Summary

Role : Business Intelligence Data Engineer (consultant type)

Location : Seattle WA (local only)

Client Preference: Looking for a consultant mindset—not just a technical developer. Candidate should be business-oriented, confident in stakeholder discussions, able to challenge requirements constructively, recommend better solutions, and take ownership rather than simply executing instructions.

Job Description:

The BI Data Engineer will support technical delivery across three focus areas: CRDM(Credit Risk Data Mart) lift-and-shift migration from SQL Server to Snowflake, tool modernization, and EDP (Enterprise Data Platform) adoption/repointing from on-prem SQL Server EDW tables to Snowflake EDW tables.

Role and Responsibilities:

Responsible for designing and building data pipelines and Business Intelligence (BI) Solutions
Data subject-matter expertise, or proven ability to identify and collaborate with the appropriate data SMEs. Works on complex projects/teams independently and acts as a mentor and leads other developers
Design and develop BI solutions using Data Sources, calculated measures, and other transformations (lookups)
Establish processes and automation for the enterprise-grade Data & BI platform
Perform Data testing and Q&A – liaison between business, developers, and other technical teams
Provide data and analytics support (i.e., SQL queries, SSAS, SAS, Alteryx workflows, Tableau, PowerBI reports and dashboards)
Perform functional testing and data validation. Develop and execute testing plans, scenarios and validate data accuracy
Test data services (data pipelines, APIs) that feed downstream requirements (Dashboards, Models, etc.) to ensure that the data is transferred correctly to the client application tools
Strong experience with data lineage and data tracing
Participate in user acceptance testing (UAT)
Ensure BECU Security, Governance, Enterprise Architecture guidance and protocols are adhered
Communicate progress, risks, and issues to the project team

Outcomes:

Following are some of the key deliverables expected from this role:

Data & BI solutions include - data pipelines, ETLs, Cubes, reports, dashboards, etc.
Test scripts and execution along with results
Produce release notes/documentation
Create documentation for change control
Produce operational support documentation, source control repository management, and runbooks
Provide end-user defect resolution and adoption support
Other project documentation and artifacts as defined and assigned by Project Manager or clients Data & BI leadership

QUALIFICATIONS

Bachelor’s degree in Computer Science, Math, IT, Business or equivalent work or educational experience required.
Minimum 7 years of experience in a related position working with data and BI solutions.
Experience as Data/Business Intelligence Developer building scalable and robust solutions
Experience leveraging AI tools to accelerate development while maintaining code quality and consistency. Snowflake AI Migration (AIM) tool / Cortex experience preferred
Strong hands-on Snowflake experience, including:
- Converting SQL Server T-SQL processes and stored procedures to Snowflake.
- Translating SQL Server DDL objects to Snowflake.
- Designing and developing migration frameworks to programmatically move data from SQL Server to Snowflake.
- Data validation and reconciliation between source and target environments.
- Performance tuning and optimization of Snowflake workloads.
Experience converting SSIS packages to Azure Data Factory (ADF) pipelines.
- Ability to establish and configure ADF environments for both Pre-Production and Production.
- Strong ETL design skills with emphasis on reusable, scalable pipeline frameworks.
- Experience with Apache Iceberg storage technology.
- Experience building and maintaining Azure DevOps (ADO) CI/CD release pipelines.
Experience with source control and DevOps such as implementing and enhancing GitHub-based source control processes and tooling.
Ability to improve repository management, branching strategies, and deployment workflows.
Experience developing and maintaining SSAS cubes using Visual Studio.
Experience migrating SSAS Cubes/Semantic Models to Power BI Semantic Models, including validation and performance optimization.
Strong demonstrated experience acting as a business liaison and delivering both strategic and operational solutions to technical teams required.
Experience owning, supporting and delivering the full data life cycle development and its various phases required.
Knowledge of data manipulation languages and tools such as Python, Alteryx etc. preferred.
Knowledge of business intelligence and data discovery tools such as Tableau, Alteryx or Power BI required.
Understanding of data engineering vocabulary and data architecture. Includes experience working with Azure, DataOps, JIRA or other Agile development team tools required.
Ability to plan, organize, schedule, and implement projects in accordance with established project management methodologies required.

Key Tools/Technologies:

Data ingestion/ETL tools such as Azure Data Factory, SSIS, etc.
SQL and other relational database concepts and languages
Data warehouses, Data Lakes, and other data products such as Snowflake, Databricks, etc.
Good understanding of SSIS and SSAS as a developer
PowerBI
SQL Server Management Studio
Azure Synapse
Advanced Excel, Word and Visio
Finance/Fintech applications, systems, processes and best practices
Expertise in source control management (ADO branching, merging, and release processes)
Ability to use pivot tables based on data cubes
Good to have experience with: Alteryx, Tableau and Python

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

Dice Id: 10504943
Position Id: 4077-12901-1784914279
Posted 5 hours ago

Company Info

About DKMRBH Inc.

Do Know Me Right Before Hiring knows the value of transparency & constant communication between the client & the project resources to build a trustworthy foundation of our name. A commitment made is a commitment honored. Our clients experience the commitment during our intensive project delivery engagements. We believe in building a reputation that will serve as a positive reflection on our clients & candidates. We measure our success by the strength of the relationships we cultivate.

At DKMRBH Inc. we understand the importance of work to our clients & aspire to honor all of our commitments to them. Deep technical & functional expertise in every aspect of the Enterprise management: Our senior management team brings a wealth of experience in leading companies, delivering a consistent record of positive results. This stems directly from our devotion to sustain, mutually benefit & build long-term relationships with our clients,

QA Engineer

Seattle, Washington

•

Today

Role : QA Engineer Location : Seattle WA (Locals only) We are seeking a highly skilled Data Migration Test Analystto support enterprise data migration initiatives into Snowflakewithin an Azureecosystem. This role will be responsible for validating the accuracy, completeness, integrity, and transformation of data as it moves from legacy platforms and data warehouses into modern cloud-based data environments. The ideal candidate will have strong experience in expertise in data validation,

Easy Apply

Contract, Third Party

Depends on Experience

Filter Results

Job post features

Posted date

Work settings

Employment type

Distance

Employer type

Work authorization

Business Intelligence Data Engineer (consultant type)

Skills

Summary

Dice Job Match Score™

Bisma Kahn

Similar Jobs

Business Intelligence Data Engineer (consultant type)

Job Details

Skills

Summary

Company Info

About DKMRBH Inc.

Dice Job Match Score™

Bisma Kahn

Similar Jobs