Data Engineering Manager

Take the next step in your journey. At Millennium Trust Company, you will help businesses and individuals thrive today, tomorrow, and into retirement. Become part of a company that is people centric and client obsessed in every interaction; a community of forward-thinking individuals focused on driving results to deliver our mission with an unwavering commitment to integrity. Join us as we strengthen and simplify the health and wealth journey - relentlessly pursuing better outcomes for all. We believe in finding the best talent! While some roles are based at one of our office locations, remote roles can sit in any of the following states: AL, AZ, FL, GA, IA, IL, IN, MI, MN, MO, NC, NE, PA, SC, TN, TX, UT, VA and WV. Remote status and role locations are subject to change. Relocation is not provided.
Don't meet every single requirement? Here at Millennium Trust, we believe there is no "perfect" candidate and want to encourage applying even if all the requirements listed aren't met. Our goal is to build an authentic workplace by valuing diversity in our candidates. We work to ensure that our team reflects the diversity of the businesses and clients we serve. We are always looking to expand our growing team with dynamic and enthusiastic individuals. If you enjoy a collaborative, fun environment that champions career development, Millennium Trust is the place for you! We look forward to receiving your application! Check out a video on our Company Culture! Millennium Trust Culture
HOW YOU WILL SOAR:
The Data Engineering Manager will report to the Sr. Director, Data Engineering in the Technology Department. This role will engage with Business Leaders, Analysts, Data Stewards, Application/ Technology Architects, and third-party providers. This role will lead an agile team of Data Engineers that work to enhance data delivery, quality, accessibility, and analysis. This role will additionally help to Improve functionality, streamline data processes, provide direct support to the business and operational teams, and strengthen targeted business strategies. The role works closely with the Business, Operations and Technology groups to help design and lead the development of the Enterprise Data Warehouse.
If you are ready to advance your career and contribute to a rapidly growing company dedicated to delivering innovative products and ensuring an exceptional client experience, we eagerly await your application!

• Lead an agile team of data engineers with varying levels of experience in the delivery of the enterprise data initiatives
• Oversee the creation of data transformation processes, data structures, metadata, dependency and workload management
• Partner with business leadership to implement 3 - 5 year plan for area of responsibility
• Manage multiple concurrent projects
• Define and establish benchmarks, metrics and quality measures
• Support disaster recovery and contingency planning
• Ensure solutions meet non-functional requirements, such as security, performance, maintainability, scalability, usability, and reliability.
• Effectively manage relevant 3rd party vendor relationships
• Support the stability and resiliency of all relevant production processes, as well as, instituting a robust support model addressing process and application failures
• Understand the business and technology
• Stay apprised of client business plan and direction
• Drive process alignment with business partners
• Identify project team requirements and capital requirements
• Evaluate and integrate productivity tools, development tools, testing tools, databases, and purchased applications into this architecture
• Work with the leaders of Technology Infrastructure and Software Engineering to ensure effective operational tools and procedures are in place to support the application architecture
• Research and strategize emerging technologies relevant to business needs
• Develop and document an overall Data Warehouse architecture which is fit for business purpose and cost effective
• Other duties as assigned

IF YOU HAVE SOME OR ALL OF THE FOLLOWING, APPLY:

• Bachelor's degree preferred in Computer Science, Computer Engineering, Software Engineering, Electrical/Electronics Engineering, Mathematics, Statistics, Data Science, or similar/related Engineering/Science based disciplines.
• 10+ years of experience in Data Engineering, Data Warehousing, or Software Product Development
• 1-3 years of leadership experience managing direct reports
• Microsoft Certified Azure Solutions Architect Expert - Preferred
• Microsoft Certified Azure Data Fundamentals
• Snowflake SnowPro Certification
• Snowflake SnowPro Certification Data Engineer
• Scaled Agile For Enterprise (SAFe)

Skills & Abilities:

• Strong understanding of Programming Skills. While not expected to perform day to day code development, the Data Engineering Manager is expected to be knowledgeable and practiced in programming languages such as SQL/T-SQL, Python.
• Data / Database Skills: Competence with relational and noSQL databases (e.g., SQL Server, MongoDB) including proficiency with Data Definition Languages, Data Mark-Up Languages
• Oversee the development of logical data models and physical database designs optimized for performance, availability and reliability
• Oversee design and implementation of OLAP databases to serve internal and external consumer use cases
• Design and implement resilient and performant data pipeline and transformation processes
• Design and implement hybrid data cloud services, leveraging public could providers (i.e. Azure) and specialty providers (i.e. Snowflake)
• Support the development of enterprise data warehouse strategy ensuring rapid delivery while taking responsibility for applying standards, principles, theories, and concepts
• Support enterprise data governance initiatives
• Strong experience in working with and optimizing existing ETL processes and data integration and data preparation flows and helping to move them in production
• Exceptional analytical skills and strong attention to detail
• Ability to prioritize, plan and take initiative
• Highly self-motivated and directed
• Experience in a high availability environment preferred
• Knowledge of ITIL/ITSM Foundational practices and framework preferred
• Strong Vendor management skills preferred
• Strong understanding of Salesforce Financial Services Cloud data object model preferred
• Data Engineering Tools/Platforms
  
  • Platform/Framework (Snowflake, Azure MSSQL)
  • ETL (Qlik Replicate, Talend, SSIS)
  • Job Orchestration (ActiveBatch, Tidal, Airflow)
  • Entity Data Modeling (ER/Studio, Erwin)
• Problem-Solving and Analytical Skills: Data engineers must possess strong problem-solving abilities and the capacity to analyze complex technical challenges. They should be able to break down problems into manageable components and devise effective solutions.
• Software Product Development Lifecycle: Familiarity with the software development lifecycle (SDLC) is crucial. This includes understanding requirements gathering, system design, implementation, testing, deployment, and maintenance in an Agile/Scaled Agile manner. Experience with Scrum, Kanban, Extreme Programming, or other outcome based iterative development approach required.
• Knowledge of Development Tools and Frameworks: Data engineers should be proficient in using development tools and frameworks relevant to their domain. This can include version control systems (e.g., Git), integrated development environments (e.g., Visual Studio Code, IntelliJ), and frameworks specific to data platform development
• Collaboration and Communication: Effective collaboration with cross-functional teams is vital for data engineers. Strong communication skills, both written and verbal, enable them to clearly express ideas, collaborate with colleagues, and convey technical concepts to non-technical stakeholders.
• Continuous Learning: The field of software engineering is constantly evolving, so a mindset of continuous learning is crucial. Staying updated with new technologies, programming languages, frameworks, and industry trends is highly valued.
• Testing and Debugging: Proficiency in automated software testing techniques, including unit testing, integration testing, and debugging, is important for ensuring the reliability and quality of software applications.
• Knowledge of Security Best Practices: Strong understanding of secure coding practices and the ability to apply them effectively in software development. Ability to implement security controls, conduct code reviews, and perform security-focused testing, ensuring adherence to industry standards and minimizing the risk of potential exploits.
• Compliance: Familiarity with regulatory compliance requirements and industry-specific security standards, such as GDPR, HIPAA, PCI-DSS, and ISO 27001. Ability to design and implement software solutions that meet these compliance standards, ensuring the protection of sensitive data and maintaining regulatory compliance.
• System Design and Architecture: Data engineers should have a solid understanding of data platform system design principles and architecture patterns. This includes scalability, performance optimization, and the ability to design robust and efficient software systems.
• Adaptability and Flexibility: Data engineers often encounter changing requirements, tight deadlines, and evolving technologies. Being adaptable, flexible, and able to quickly learn and adapt to new tools and frameworks is crucial.

MILLENNIUM TRUST COMPANY is a rapidly growing, leading financial services company offering specialized retirement and institutional services and recently acquired PayFlex, a consumer directed benefits provider, to create a personalized, holistic approach to financial wellness. To that end,we provide a diversified multi-product business with a holistic focus on financial wellness. Millennium Trust has experienced year-to-year double digit growth and prides itself on its strong, progressive culture.
We have been recognized for our remarkable growth on lists such as Crain's Fast 50 and Inc. 5000, and for our outstanding workplace culture and benefits with Built In's 2023 Best Places to Work and Gallagher's 2022 Best-In-Class Employer awards.