Note: The job is a remote job and is open to candidates in USA. Municipal Credit Union is a financial institution dedicated to helping New Yorkers build better tomorrows. The Data Engineer will be responsible for designing, building, and maintaining data pipelines and models to support enterprise analytics and application development.
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
Skills
- 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 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
- Desirable experience with SharePoint for collaborative products and workflows
Benefits
- 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
- 11 paid holidays annually
Company Overview