Manager, Data Integration Engineer

Lighthouse Document Technologies Inc.; United States; Remote; USD 138,000 - 150,000; Full time

Job summary

Lighthouse Document Technologies Inc. is seeking a remote Manager, Data Integration Engineer to lead a team in data integration and ETL processes. The role involves collaborating with various stakeholders and ensuring timely delivery of data to support enterprise users. The ideal candidate will possess extensive experience in data warehousing, SQL, and management, making significant contributions to the data warehouse team's success.

Benefits

Comprehensive medical, dental, and vision benefits

401k with company match

Flexible PTO program

Paid volunteer days

Qualifications

• 10+ years’ experience in Data warehousing and BI projects.
• 15+ years’ experience in SQL and knowledge in databases.
• Strong technical skills in data warehousing implementation.

Responsibilities

• Lead and manage data integration development team and ETL processes.
• Collaborate with business stakeholders to deliver data integration.
• Maintain data lineage documents and conduct requirement review sessions.

Skills

Data Warehousing

SQL

Data Governance

Data Analysis

ETL Design

Education

BS in Computer Science or related field

Tools

MicroStrategy

Power BI

Job description

If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process.

Manager, Data Integration Engineer

Full Time Remote, Remote, US

7 days ago Requisition ID: 2382

Salary Range: $138,960.00 To $150,000.00 Annually

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 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.