Note: The job is a remote job and is open to candidates in USA. Fractal is a strategic AI partner to Fortune 500 companies with a vision to power every human decision in the enterprise. The Senior BI Data Engineer will support technical delivery focusing on data migration, tool modernization, and enterprise data platform adoption.
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
- 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 Data & BI leadership
Skills
- 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
- 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 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
- Experience leveraging AI tools to accelerate development while maintaining code quality and consistency. Snowflake AI Migration (AIM) tool / Cortex experience preferred
- Knowledge of data manipulation languages and tools such as Python, Alteryx etc. preferred
- Good to have experience with: Alteryx, Tableau and Python
Benefits
- Eligible for a discretionary bonus for the current performance period
- Eligible to participate in the health, dental, vision, life insurance, and disability plans in accordance with the plan documents, which may be amended from time to time
- Eligible for benefits on the first day of employment with the Company
- Eligible to participate in the Company 401(k) Plan after 30 days of employment, in accordance with the applicable plan terms
- The Company provides for 11 paid holidays and 12 weeks of Parental Leave
- We also follow a “free time” PTO policy, allowing you the flexibility to take the time needed for either sick time or vacation
Company Overview