Business Intelligence Data Engineer

Connexus Credit Union
1dRemote

About The Position

We are seeking a highly skilled Business Intelligence Engineer to design, build, and optimize our Power BI environment and data infrastructure. This role combines technical expertise with team leadership and mentorship, guiding best practices without formal management responsibilities. The ideal candidate will have strong experience in data engineering, BI development, and governance, with the ability to collaborate across teams and influence technical direction.

Requirements

  • Bachelor’s degree in computer science or engineering or commensurate experience is Required.
  • 3+ years of prior experience in data engineering and business intelligence development is Required.
  • Experience in writing SQL/NoSQL; Solid understanding of relational databases and business data; ability to write complex queries against a variety of data sources is Required.
  • Experience developing back-end, cloud data warehouse solutions like Snowflake (e.g., managing staging and external tables, variant data types, etc.) is Required.
  • Experience in data engineering or data architecture concepts including approach, data lakes, data extraction, and data transformation is Required.
  • Looker and/or Power BI Dataset creation/maintenance.
  • Hands-on experience with AWS cloud technologies (S3, AWS Glue, Glue Catalog, Athena, AWS Lambda, AWS DMS, PySpark, and Snowflake).
  • Experience with credit union and bank vendors (MeridianLink, nCino, Fiserv, etc.)
  • Working knowledge of Business Intelligence tools (SSRS, SSAS, SSIS, Looker, PowerBI, DAX).

Nice To Haves

  • AWS, Snow Pro, Power BI and Microsoft Azure Certifications.

Responsibilities

  • Design, build, and support data warehousing (Data Vault 2.0) and BI solutions.
  • Develop, promote, and provide ongoing support for ETL workflows.
  • Develop and validate sources to target mappings and transformation logic.
  • Design and maintain data models used for reporting and analytics.
  • Modify existing reports, extracts, and dashboards, as necessary.
  • Supports data automation, quality, and governance.
  • Conduct data profiling, data cleansing, and assessing the integrity of data from multiple sources to ensure high quality data.
  • Support development of Data Dictionaries and Data Taxonomy for product solutions.
  • Collaborate with infrastructure team to design and implement internal process improvements, greater scalability, optimization of data delivery, and automating manual processes.
  • Assist in data migration and data ingestion to core systems during active mergers, acquisitions, or other assigned projects.
  • Create reusable datasets in support of insights and analytics for the organization.
  • Create and maintain information and data flow diagrams.
  • Leverage existing data infrastructure to fulfill all data-related requests, perform necessary data housekeeping, data cleansing, normalization, hashing, and implementation of required data model changes.
  • Help the broader team identify new features and business opportunities through analysis.
  • Support upgrades, configuration and troubleshooting for business intelligence tools.
  • Identify development needs to improve and streamline operations.
  • Drive best practices in code quality & reusability, data integrity, test design, analysis, validation, and documentation.

Benefits

  • 25 days of paid time off and 10 paid holidays
  • 16 hours of paid Volunteer Time Off
  • 401K Retirement with up to 6% employer match
  • Excellent Health, Dental, Vision insurance, including multiple plan options
  • Health Savings Account with generous employer contributions
  • Employer paid Life insurance, Short-Term and Long-Term Disability
  • Tuition Reimbursement from $4,000 - $7,000 per calendar year
  • Robust Learning and Development program that includes an annual professional development stipend
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service