Role Overview

ExpertLogix advises, architects, selects, and implements solutions for clients so that they may efficiently run their businesses, with a focus on data analytics in the cloud. These service areas span IoT, Solution Architecture, data engineering, analytics, AI, ML, and DevOps.

We are looking for a savvy Cloud ETL Engineer to join our growing ExpertLogix team of data professionals. The hire will be responsible for expanding and optimizing our data pipeline architecture, as well as optimizing data flow and collection for cross-functional teams. The ideal candidate will be well versed in SQL, Data Warehousing principles & practices, and the use of ETL Tools on-premises and in the cloud. The Cloud ETL Engineer will support our software developers, database architects, data analysts, and data scientists on data initiatives and will ensure optimal data delivery architecture is consistent throughout ongoing projects. They must be quick learners, self-directed and comfortable supporting the data needs of multiple teams, systems, and products. The right candidate will be excited by both green-field and large-scale migration projects – learning and using new tools – and ready to drive their personal growth.Duties & Responsibilities:

• Develop, construct, test and maintain ETL/ELT architectures
• Work with Architects to ensure development work aligns with business requirements
• Data acquisition and ingestion for data at rest or streaming data
• Utilize ETL tools to build and deploy data ingestion and transformation pipelines
• Use enterprise orchestration tools
• Translate ETL from Source to Target documentation and from one ETL tool to another
• Will be responsible for conversion of ETL Tools or re-directing ETL Jobs to utilize the cloud as a target data source
• Identify ways to improve data reliability, efficiency, and quality
• Deliver updates to stakeholders based on analytics
• Ensure accuracy & integrity of data & applications through analysis, coding, writing clear documentation & problem resolution
• Analyze & translate functional specifications & change requests into technical specifications
• Develop, test & implement program logic
• Translate business needs into end-user applications

Other responsibilities:

• Must be an excellent communicator in terms of status and raising issues that might impact projects to either project or account management
• While not engaged, work on internal projects and learning exercises to:
  • Extend your technical knowledge and skills by working with standard stack and new tools
  • Work on internal tech aimed to help build new technical practices
• Participation is encouraged to assigned training and obtain certifications as identified by the ITT department and/or ExpertLogix Professional Growth Manages for Role:

Soft Skills Required:

• High level of personal initiative and energy
• Excellent verbal and written communication skills
• Capable of working autonomously with minimal oversight
• Willing to raise issues to ExpertLogix or client management as required, clearly defining the issue and potential solutions
• Common sense approach to problems
• Capable of adapting written processes when required and capturing improvements to the process for later review
• Highly analytical and curious
• Ability to influence internal and external teams
• Confident and demonstrate strong leadership
• Ability to adapt to a fast-paced environment with high tolerance to change management
• Comfortable in working in a virtual environment (i.e., conference calls)
• Results oriented
• Self-motivated, autonomous

Technical Skill Sets (Mandatory):

• Experience with implementing cloud data warehouses – Snowflake, AWS Redshift, Azure SQL Data Warehouse, or Google BigQuery experience considered
• Experience with building data pipelines – using a variety of different technologies; Informatica, Matillion, dbt, DataStage, etc.
• Candidates must have direct work experience developing and deploying at least one project where they implemented the full cloud data pipeline documented on their resume
• Strong understanding of SQL (2-4 years)
• Experience gathering and tracking requirements
• Highly analytical and curious
• Demonstrated problem-solving skills
• Ability to influence internal and external teams
• Confident and demonstrate strong leadership
• Ability to adapt to a fast-paced environment with high tolerance to change management
• Comfortable in working in a virtual environment (i.e., conference calls)
• Results-oriented, self-motivated, and autonomous

Knowledge of the following would be an asset:

• Open-source contributions of any sort
• Experience creating performance dashboards and scorecards using business intelligence dashboards such as SpotFire, Tableau, PowerBI,Cognos, MicroStrategy, etc.
• Data cataloguing and governance techniques
• Strong Agile methodology knowledge
• Drive for continuous process improvement

Travel Expectations:
When work returns to normal (post-Covid) the Candidates must be available to travel up to
two weeks per month regularly, with occasional periods of 2 to 3 weeks per month based on
specific client requirements if needed