Business Intelligence Data Engineer
Connexus Credit Union
full-time
Posted on:
Location Type: Remote
Location: Florida • Illinois • United States
Visit company websiteExplore more
About the role
- 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.
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).
- AWS, Snow Pro, Power BI and Microsoft Azure Certifications.
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
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
data warehousingETL workflowsdata modelingdata profilingdata cleansingSQLNoSQLcloud data warehousedata engineeringdata architecture
Soft skills
collaborationproblem-solvinganalytical thinkingcommunicationattention to detailprocess improvementcreativityadaptabilityteamworkleadership
Certifications
AWS CertificationSnow Pro CertificationPower BI CertificationMicrosoft Azure Certification