Data Engineer

Municipal Credit Union; United States; On-site; USD 106,300 - 150,000; Full time

Benefits offered by this job

Medical, vision, dental insurance

401(k) with employer match

11 paid holidays annually

Discretionary bonus

Job summary

Municipal Credit Union seeks a data engineer to design, build, and maintain data pipelines and models supporting enterprise analytics and application development.

You will integrate data from diverse sources, perform ELT, and ensure data quality for reliable business insights. The role requires strong SQL, .NET/C#, and SQL Server expertise, with CI/CD and Agile experience.

Qualifications

• Bachelor's degree in information systems, computer science, or engineering with 6+ years of experience required.
• Strong SQL and data pipeline expertise; experience with Fabric and Azure Data Factory.
• Deep knowledge of ETL, data warehousing concepts, and data quality practices.
• Proficiency in .NET (C#) and Microsoft SQL Server; SSIS package development.
• DevOps tooling and CI/CD experience; QA and Agile methodologies.

Responsibilities

• Design, build, and maintain robust data pipelines and models for analytics.
• Integrate data from multiple sources and perform ELT operations.
• Validate data quality and ensure reliability across data stores.
• Develop and optimize database code, indexes, and queries for performance.
• Collaborate with Analysts, Product Managers, and business users to gather requirements.
• Lead end-to-end lifecycle of software and data applications within Agile sprints.
• Participate in monthly on-call rotation and ensure regulatory compliance.

Skills

SQL

Data pipelines

Azure Data Factory

ETL

Data quality

NET/C#

Microsoft SQL Server

SSIS

Data modeling

DevOps

Education

Bachelor's degree in information systems/Computer Science/Engineering

Tools

Fabric

Azure DevOps

SSIS

Crystal Reports

SQL Server Management Studio

Symitar

PowerOn

SymXchange

OpCon

Job description

Overview

The data engineer is responsible for designing, building, and maintaining robust data pipelines and models that support enterprise analytics and application development. This role requires a strong background in data integration, transformation, and quality assurance, ensuring that data is consistently reliable, accurate, and usable for business needs.

Responsibilities

• Integrate data sets from various source systems into unified formats.
• Perform ELT (Extract, Load, Transform) operations to convert source data types into standardized target formats.
• Cleanse and transform data by applying business rules to ensure consistency and usability.
• Conduct data cleansing and validation to meet enterprise data quality standards.
• Monitor and troubleshoot data issues to maintain high reliability and accuracy.
• Create and maintain conceptual, logical, and physical data models.
• Ensure models align with business requirements and support analytics and application development.
• Build and maintain data pipelines that retrieve, standardize, and transform data from source systems.
• Load processed data into analytical data stores and prepare it for consumption by developers and analysts.
• Monitor the performance and quality of data transfers between source and target systems.
• Integrate test suites into CI/CD pipelines to ensure continuous validation of data pipelines.
• Optimize data flows for efficiency, scalability, and reliability.
• Communicate well and work closely with team members including Analysts, Product Managers, and business users to gather requirements, troubleshoot, modify, and enhance existing data assets.
• Develop backend applications in Database using TSQL/PLSQL in Microsoft SQL Server. Write complex code in stored procedures or PL/SQL.
• Troubleshoot to find root cause with data accuracy and/or performance related issues and find solutions to fix it by creating indexes, transaction isolation levels and optimizing code.
• Resolve database performance issues by looking at query plans, create appropriate indexes, resolve dead locks and create table hints.
• Ability to support the team in a high-volume environment to meet deadlines while maintaining exceptional attention to detail.
• Function as an expert and perform optimally within an agile development framework, properly creating or leading the team to create user stories and estimating effort and duration.
• Lead and manage end-to-end life cycle to produce software and applications through project conception to completion.
• Adhere to all regulatory compliance training inclusive of BSA/AML/OFAC and overall BSA/AML/OFAC compliance.
• Participate in monthly on-call rotation.
• Perform other related duties as requested and special projects as assigned.
• Written and verbal communication skills.
• Ability to communicate with other members of the team.
• Highly Ethical.

Requirements

• Bachelor’s degree in information systems, Computer Science, Engineering, or related field, or the equivalent combination of education, training, and 6-8 years of experience.
• Proficiency in SQL and data pipeline tools (e.g., Fabric, Azure Data Factory).
• Expertise in delivering and improving data quality in a Big Data environment in cloud for Enterprise Data Lake (Azure or similar), Data Warehouse (Azure Synapse or similar), and Data Hubs (Azure Cosmos DB or similar).
• Strong understanding of ETL processes and data warehousing concepts.
• Experience with DevOps toolset (Azure DevOps or similar) to collaborate and deploy code.
• Experience in Test case design, execution, and defect tracking.
• Familiarity with QA methodologies (e.g., Agile, Scrum).
• Excellent verbal and written communication skills, with the ability to effectively communicate complex concepts to stakeholders at all levels.
• Experience with data modeling and metadata management.
• Familiarity with data quality frameworks and validation techniques.
• Ability to troubleshoot and resolve data-related issues quickly and effectively.
• Excellent communication and documentation skills to support cross-functional collaboration.
• Expertise in .NET based architecture, including advanced concepts like enterprise application integration. Deep knowledge of C# and its application in building scalable, high-performance systems.
• Advanced skills in Microsoft SQL Server, including database optimization, performance tuning, and complex SSIS package development.
• Extensive experience with Reporting tools such as Crystal Reports or SQL Reports.
• Familiarity with Symitar and its related technologies such as PowerOn, SymXchange, OpCon, and ARCU. This is a key differentiator for this role.
• Other: Desirable experience with SharePoint for collaborative products and workflows.

Benefits

The pay range for this position is between $106,300-150,000 annually. Actual base pay offered may vary depending on a number of factors such as job-related knowledge, skills, experience, and location. Employees in this position may also be eligible for a discretionary bonus, 401(k) with an 6% employer match per pay period. Benefits for this position include Medical, vision, dental, life, and disability insurance, flexible paid time off and 11 paid holidays annually.

Municipal Credit Union (MCU) is an Equal Opportunity Employer. Municipal Credit Union provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by applicable federal, state or local laws. We are committed to hiring, training, cultivating, promoting, and celebrating an environment where we have a welcoming and fulfilling place for all people to call home. Diversity of race, thought, sexual orientation, age, veteran status, religion, and disability will empower us to thrive as individuals, as teams, and as an organization.