Sr. Data Warehouse Engineer (Remote)

Take the next step in your journey at Inspira Financial. 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 Inspira Financial, 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, Inspira Financial is the place for you! We look forward to receiving your application! Check out this Inspira Financial video to learn more about our company!
HOW YOU WILL SOAR:
We are seeking talented Data Engineers who can create scalable data platform solutions while collaborating with an experienced team of product development professionals. You will join a cross-functional, DevOps based, Agile team responsible for the entire product development life cycle, encompassing conception, discovery, framing, development, deployment, measurement, and continuous improvement.
As a Data Engineer, you should possess expertise in creating large-scale data engineering pipelines, end to end ETL load processes, designing and architecting ETL load processes, understanding admin, scheduling and infrastructure technologies supporting data warehouse platform, modern data-centric coding languages, development frameworks, and ETL load processes. Additionally, we value individuals who are team players, possess a keen eye for visual design, and prioritize outcomes over outputs.
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!
The Sr Data Engineer will report to the Manager Data Engineer in the Technology.
Duties & Responsibilities:

• Collaborating with Users, Engineers, Designers, and Product Managers to foster ideation and deliver cutting-edge software solutions.
• Experience developing production-grade data pipelines (using ETL tools and technologies etc.) for Data Warehousing and resolve any roadblocks hands on in timely manner.
• Experience working on a large Data Warehouse, creating and maintaining data flows that integrate information from various sources into a common pool implementing data pipelines based on the ETL model.
• Experience with SQL and NoSQL databases like Snowflake etc.
• Experience working with extremely large data sets (TBs) environment and be able to handle performance issues in continuously scaling up environment.
• Be ready to wear multiple hats including administering multiple tools like Snowflake, Talend , Qlik Replicate, Scheduling Tools like Active Batch etc.
• Experience creating POCs for testing and implementing new technologies and tools and be able to partner with multiple teams in resolving inter team dependencies.
• Be ready to switch gears and if needed and be able to guide other team members on technology front and resolve any issues they may be facing.
• Work closely with POs/PMs and Scrum master in planning future iterations and making sure that developers can deliver their code and deploy within the assigned sprint.
• Creating and maintaining architectural designs for architecturally significant projects.
• Data Modelling and designing tables schemas for new or existing warehouse enhancements.
• Employing Test First and Acceptance Criteria Driven approaches to continuously test and deliver high-quality software.
• Designing and developing data pipelines while adhering to industry best practices and standards.
• Ensuring solutions meet non-functional requirements, such as security, performance, maintainability, scalability, usability, and reliability.
• Actively pursuing continuous professional growth by staying updated on new development tools, programming techniques, and computing equipment. Engaging in educational opportunities, keeping informed through professional publications, nurturing personal and professional networks, and actively participating in relevant professional organizations.
• Through the successful execution of these responsibilities, the data engineer will make significant contributions to the overall achievements of our team and organization!

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

• 5-7 years of Data Engineering or Software Product Development.
• Bachelor's Degree required in Computer Science, Computer Engineering, Software Engineering, Electrical/Electronics Engineering, Applied Mathematics, Statistics, Data Science, or similar/related Engineering/Science based disciplines.
• Platform/Framework (Snowflake, Azure MSSQL)
• ETL (Qlik Replicate, Talend, SSIS, Stored Procedure)
• Job Orchestration (ActiveBatch, Tidal, Airflow)
• Entity Data Modeling (ER/Studio, Erwin, Oracle Data Modeler)
• Microsoft Certified Azure Developer Associate - Preferred
• Microsoft Certified Azure Data Fundamentals
• Snowflake SnowPro Certification
• Snowflake SnowPro Certification Data Engineer
• Certified Ethical Hacker
• Scaled Agile For Enterprise (SAFe)

Skills & Abilities:
The ideal candidate will have a proven track record of demonstrating:

• Strong Programming Skills: Proficiency in programming languages such as SQL/T-SQL, understanding of ETL tool components, Snowflake, GitHub repo, and administration with any tool or technology. Data engineers should have a deep understanding of data structures, Stored Procedure, algorithms, and the ability to write clean, efficient, and maintainable code.
• Data / Database Skills: Competence with relational and noSQL databases (e.g., SQL Server, MongoDB) including proficiency with Data Definition Languages, Data Mark-Up Languages and ability to design and create database tables, views, functions and stored procedures
• Facilitate the development of logical data models and physical database designs optimized for performance, availability and reliability
• Work with the Database Architect to help design and manage the Enterprise data model which spans internal systems, as well as, external third party processing systems for the collective benefit of Marketing, Operations, Sales and Executive teams
• Design and implement 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, and drive efforts in defining data standards, designing classification taxonomies, developing data management processes, ensuring proper meta-data management
• Work cross-functionally with other internal business units, such as, marketing and operations
• 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.
• 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

Other Requirements:

• Infrequent travel (10%)
• Ability to provide personal transportation from time to time
• Ability to work overtime
• Prolonged periods of sitting at a desk and working on a computer

Inspira Financial provides health, wealth, retirement, and benefits solutions that strengthen and simplify the health and wealth journey. With more than 7 million clients, representing over $62 billion in assets, Inspira works with thousands of employers, plan sponsors, recordkeepers, TPAs, and other institutional partners - helping the people they care about plan, save, and invest for a brighter future. Inspira relentlessly pursues better outcomes for all with our automatic rollover services, health savings accounts, emergency savings funds, custody services, and more. Learn more at inspirafinancial.com.
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.