Remote ETL Developer

Company : ABC Fitness Solutions

It's fun to work in a company where people truly BELIEVE in what they're doing!

We're committed to bringing passion and customer focus to the business.

Job Description

We are seeking a talented individual to join our team as an ETL Developer. This individual will directly supporting the design, development, and integration of custom ETL code into Oracle and Microsoft SQL Server DB's. The ETL Developer will be responsible for complex design, development, testing, implementation, and ongoing support of the process of extracting, transforming and loading data from disparate application systems into a production database, as well as reporting and other database processing needs.

WHAT'S IN IT FOR YOU:

• A work environment built on ideation, collaboration, and our Core Values of integrity, excellence, results, respect, team & community.
• A fast-growing & fast-paced start-up culture prime for the picking. It's a vibe!
• People-focused benefits including Medical, Dental, Vision, 401K/ RRSP & Best Life
• Open paid-time-off
• Paid "Giving Back' days to allow you to volunteer for a cause that is meaningful to you
• "Pawternity" days
• Employee Assistance Program
• Fitness perks subsidies
• Parental leave
• Club Excellence
• Calm App premium subscription for you, and 5 dependents
• Tuition reimbursement
• Work fully remotely from anywhere in Canada or the United States

WHAT YOU'LL DO:

• Design, develop, test, implement, and maintain code for ETL, reports and other needs.
• Versioning and ETL changes as per the requirements, experience with a variety of transformations like Aggregate, Derived Column, Conditional Split and Data Conversion, Transaction, Checkpoints, SSIS Package Management, Debugging, Error handling and logging, SSIS Package deployment etc
• Design and develop ETL using SSIS/ADF from heterogeneous data sources.
• Create/Modify complex and large queries, writing/modifying stored procedures, functions, implementing error handling logic, performance tuning and query optimization, bug fixing, data auditing, SSIS package creation/modification and Production Job monitoring.
• Strong concepts of Data Warehousing, strategies for ETL, identifying metrics, dimensions, hierarchies, and design dimensional schema (Star, Snowflake) and implementing slowly changing dimension etc.
• Work closely with different teams for manual processes as well as resolving issues.
• Troubleshoot data and workflow issues within the data warehouse, as well as transactional databases
• Work closely with team members, DBAs, and business analysts to implement a sound solution, while adhering to agile methodology and lean integration techniques
• Automate and monitor jobs, rectifying issues within a timely manner ensuring SLAs are met
• Logical and physical database design following best practices and standards
• Work efficiently to resolve production support issues, escalating issues as needed.
• Maintain proficiency in a variety of computer programming languages, such as SQL, PL/SQL, Unix shell scripting, in order to successfully complete the tasks of the role.
• Update and maintain Entity Relational Diagrams as required.
• Provide documentation of new processes, as well as update and maintain existing documentation as needed.

WHAT YOU'LL NEED:

• Minimum 5 years experience programming using PL/SQL.
• Experience using Oracle Transactional Database.
• Bachelor's degree in Information Technology or related field from an accredited college or university.
• Minimum 2-3 years Data Warehousing/ETL experience, using SSIS.

But wait, there's more

BONUS SKILLS:

• Hands-on experience with gathering business requirements, documenting the reporting and analysis specifications, designing technical architecture, installing and configuring all components of an ETL tool, creating complex mappings, sessions, and workflows. Demonstrates sound understanding of development methodology.
• Demonstrates strong experience writing SQL, PL/SQL, and Unix Shell scripts.

• Experience on Microsoft Azure cloud services used like Storage services, Azure Databricks, Azure Data Lake, Azure Data Factory, Virtual Machines, App Service, Azure Active Directory, Azure Scheduler etc.
• Experience developing using Oracle APEX
• Proficient in a variety of computer programming languages, such as SQL, PL/SQL, Unix shell Scripting, to successfully complete the tasks of the role.
• In depth knowledge of relational database systems.
• Able to set and achieve standards, goals, and objectives with minimal supervision. Ability to clearly prove value to the company and achieve profitable results.
• Ability to fit, mold, and adapt within the dynamics of multi-functional, self-directed workgroups. Ability to encourage and assist peers in reaching their individual and team-oriented goals and objectives.
• Effectively convey the needs of our products to vendors and prospective suppliers. The ability to effectively convey the capabilities and limitations of equipment, hardware, drivers, etc. to ABC Developers, Business Analysts, and other internal staff. Ability to write reports that effectively convey information in concise, readable terms.
• Ability to effectively present ideas and solutions to small or large audiences of customers, clients, vendors, suppliers, managers, and other stakeholders. Able to relate to both technical and non-technical users.
• Build and foster positive interpersonal rapport with internal and external stakeholders.
• Ability to discern when the business goals and objectives of others might take precedence over assigned goals and objective.
• Must be able to identify problems based on subtle indicators. Must be able to develop options to solve problems in a timely manner and apply logic and reasoning to determine and implement optimum solutions.
• Ability to problem solve using deductive reasoning skills in a timely manner

• Flexibility and adaptability to frequent change

ABC'S COMMITMENT TO DIVERSITY, EQUALITY, BELONGING AND INCLUSION:

ABC is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. We are intentional about creating an environment where employees, our clients and other stakeholders feel valued and inspired to reach their full potential and make authentic connections. We foster a workplace culture that embraces each person's diversity, including the extent to which they are similar or different. ABC leaders believe that an equitable and inclusive culture is not only the right thing to do, it is a business imperative. Read more about our commitment to diversity, equality, belonging and inclusion at abcfitness.com

ABOUT ABC:

ABC Fitness Solutions (abcfitness.com) is the premier provider of software and related services for the fitness industry, and has built a reputation for excellence in support for clubs and their members. ABC is the trusted provider to boost performance and create a total fitness experience for members of clubs of all sizes whether a multi-location chain, franchise or an independent gym.

Founded in 1981, ABC helps nearly 16,000 clubs and facilities globally perform better and more profitably offering a comprehensive SaaS club management solution that enables club operators to achieve optimal performance. ABC Financial is a Thoma Bravo portfolio company, a private equity firm focused on investing in software and technology companies (thomabravo.com).

If you like wild growth and working with happy, enthusiastic over-achievers, you'll enjoy your career with us!