Manager, Data Integration Engineer

Lighthouse; United States; Remote; USD 120,000 - 150,000; Full time

Job summary

Lighthouse is seeking a Manager of Data Integration to lead a team focused on ETL development and data analysis. This role involves working closely with business stakeholders and data architects to ensure timely data delivery for an enterprise data warehouse. Ideal candidates will bring over a decade of experience in data warehousing, strong SQL skills, and the ability to manage teams effectively. The company values innovation and collaboration, fostering an environment where diverse talents can thrive.

Benefits

Comprehensive quality benefits package

401k with company match

Flexible PTO program

Paid volunteer days

Annual bonus or incentive program

Qualifications

• 10+ years of experience in data warehousing and business intelligence projects.
• 5 years of quality assurance experience in an enterprise data warehouse environment.
• Hands-on manager with solid technical skills in data warehousing implementation.

Responsibilities

• Lead and manage data integration development team and ETL processes.
• Collaborate with stakeholders for requirement reviews and data delivery.
• Troubleshoot ETL processes and maintain data lineage documentation.

Skills

Data warehousing

SQL

ETL Development

Data analysis

Data governance

Data modeling

Interpersonal skills

Communication skills

Education

BS in Computer Science or related field

Tools

Informatica

Talend

MicroStrategy

Power BI

Job description

What is special about Lighthouse?

Lighthouse is built on a foundation of unique, compassionate, highly driven individuals. We elevate the strengths and talents of those around us while leveraging opportunities for growth. We offer the experience of solving complex problems while continuing to grow multiple facets of your career. Lighthouse is where innovation meets support and where collaboration is the key ingredient to success. We grow together and are stronger together.

What’s unique about this role?

Leading and managing data integration development team, data analysis. ETL Development and Load monitoring tasks to deliver quality data integration objects for successful EDW program.

What will this person do?

• The Manager, Data Integration, works collaboratively with business stakeholders, data architects, ETL development Developers and other analysts to develop Data integration and ETL platform and deliver data on time to support users of EDW.
• Manage and Lead ETL Team and ETL Development to meet the requirements of stakeholders.
• Maintain data lineage documents, process flow and data flow designs with the help of architect and analysts.
• Lead and Manage Requirement review sessions with Enterprise data warehouse team.
• Design & Develop ETL and data strategy and Support and Review BI Architecture
• Perform troubleshoot on all ETL processes & Reports and resolve issues effectively.
• Maintain & develop various database scripts and tools to facilitate automation process &Provide support to all data warehouse initiatives.
• Manager and govern the team to implement meta data standards for the data warehouse.
• Monitor processes and develop plans to provide the data on time.
• Develop and implement various work plans for projects and Review test plans and executions.
• Evaluate all proposals requests and assist to improve the structure of the Data warehouse.

Bring your passion and together we will shine. It would also be great if you had the following:

• BS in Computer Science or related field or an equivalent combination of education and/or experience
• Experience 10 plus years’ experience in Data warehousing and business intelligence projects
• 15 Plus years’ experience in SQL and knowledge in databases
• Five (5) years of experience in developing test plans and providing quality assurance in a large heterogeneous organization with at least 3 years of that experience in support of an enterprise data warehouse environment.
• Experience in developing technical requirement documents, interviewing business users and stakeholders.
• Experience in handling offshore team model and conducting UAT Phase with Users
• Experience in working with ETL Team and Reporting Team during design and development.
• This is a "hands-on" manager position requiring solid technical skills in data warehousing implementation, as well as data knowledge, excellent interpersonal and communication skills.
• Advanced Proficiency in full cycle of Data Warehouse and BI implementation
• Expert Knowledge in Data Profiling, data modeling, data governance
• Expert Knowledge in ETL tools like informatica talend, etc.
• Expert Knowledge in BI Tools like MicroStrategy, Power BI etc.
• Advanced Proficiency in data analysis, ETL Design, Data validation

Work Environment and Physical Demands

• Duties are performed in a typical office environment while at a desk or computer table.
• Duties require the ability to use a computer, communicate over the telephone, and read printed material, in a quiet and professional setting.
• Duties may require being on call periodically and working outside normal working hours (evenings and weekends).

Lighthouse celebrates and thrives on diversity and is an Equal Opportunity Employer. We hire, train, and promote regardless of race, religion, color, national origin, sex, disability, age, veteran status, and other protected status as required by applicable law. We welcome any talents and contributions you can bring to the team and are deeply committed to growing an environment where everyone can feel safe, is respected, and can show up as themselves. Come as you are!

As required by applicable pay transparency laws, Lighthouse complies with compensation disclosure requirements for roles that may be hired in locations under these requirements. Factors that may be used to determine your actual salary may include a wide array of factors, including: your specific skills and experience, geographic location, or other relevant factors. The salary range for this position may be tailored to be lower or higher in different talent markets.

Lighthouse offers a comprehensive quality benefits package including medical, dental, vision, and a 401k with company match. Company paid benefits also include Life & AD&D, short and long-term disability, telemedicine, and other wellness plans. We offer a generous Flexible PTO program and paid volunteer days. Employees may also participate in voluntary insurance plans including accident, hospitalization, and critical illness plans as well as pet insurance.

This role will be eligible to participate in an annual bonus or incentive program.

As a trailblazer and catalyst for change, Lighthouse rises to each opportunity to help our clients, and our people do what they do best—shine.