Manager, Reporting

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

INTRODUCTION: 

WHAT YOU’LL DO: 

• • Building and overseeing a team of ETL Developers responsible for the details of data resource design, development, and delivery - 
    Facilitating cooperation and coordination between data stewards, data architects, and technical architects, ensuring data resources are designed and developed from business needs, to logical design, to physical implementation 

  • Managing team of ETL Developers, prioritizing/assigning/managing work assignments/, coordinating with business users on time expectations 

  • Design, develop, test, implement, and maintain PL/SQL code for ETL, reports and other needs. 

  • Expert understanding of data models, database schemes, and optimization in domain driven design 

  • Solid understanding of ETL design patterns, standard methodologies, and ETL tools 

  • Experience with SDLC and agile project delivery methodologies such as Scrum 

  • Work closely with different teams for manual processes as well as resolving issues. 

  • Troubleshoot data and work flow 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 

  • Monitor and resolve issues with Golden Gate 

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

  • Departmental Expectations 

  • Flexibility - ABC is a client centric organization requiring a great deal of flexibility 

  • Professional Development is offered and expected for all Software Development positions. You must have the initiative to keep your manager informed of your desired development goals. 

  • Participate in Daily Status update 

  • Participate in on call rotation based on the number of individuals on the team. 

  • Respond to calls outside of on call rotation as needed to assist other team members or provide additional support. 

  • Proficient and professional communications 

  • Peer and stakeholder reviews are held annually and require all to participate in a timely manner 

  • Perform other duties as assigned by manager or management 

  • Regular and reliable attendance required 

WHAT YOU’LL NEED: 

• • The ability to design and deliver solutions across the enterprise in a timely fashion while balancing multiple competing priorities 

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

  • In depth knowledge of relational database systems, specifically Oracle 

  • Autonomy & Self-Management – Ability to set and achieve standards, goals, and objectives with minimal supervision. Ability to clearly prove value to the company and achieve profitable results. 

  • Teamwork – 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. 

  • Communication Skills – Ability to 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. 

  • Rapport Building – Ability to build and foster positive interpersonal rapport with internal and external stakeholders. 

  • Communications – 

  • Critical Thinking & Discernment - Ability to discern when the business goals and objectives of others might take precedence over assigned goals and objective. 

  • Problem Identification and Solving - 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 
    
    EDUCATION / EXPERIENCE: 

  • • Bachelor’s degree in Information Technology or related field from an accredited college or university. 

    • Minimum 10-15 years Data Warehousing/ETL experience 

    • Expertise in leading practice data integration, modeling, and warehousing principles 

    • 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 with Oracle Developer Tools such as Enterprise Manager and SQL Developer. 

    • Analytical and mathematical minded, capable of evaluating and solving complex data management problems 

    • Familiar with Cloud Technologies / ETL Tools in AWS 

    WHAT’S IN IT FOR YOU:  

     

    • Purpose led company with a Values focused culture – Best Life, One Team, Growth Mindset  

    • Time Off – with our open PTO policy, we offer flexibility in how and when you take PTO! 

    • Days of Disconnect – once a quarter, we take a collective breather and enjoy a day off together around the globe. #oneteam  

    • Parental & Pawternity Leave – we offer leave for when your family grows by two feet or four paws!  

    • Best Life Perk – we are committed to meeting you wherever you are in your fitness journey with a quarterly reimbursement  

    • Medical/Dental/Vision coverage  

    • EAP – we get you help when you need it. Period.  

    • Premium Calm App – enjoy tranquility with a Calm App subscription for you and up to 4 dependents over the age of 16 

    • And more! – so many benefits we couldn’t even fit them all here! 

     

    Please note that the salary information shown below is a general guideline only and based on employees in the United States and may be different in other countries. Salaries are based upon candidate experience, qualifications, and location, as well as market and business considerations. Our pay range for U.S. based candidates for this position is $84,000 -- $118,000 USD annually. Your recruiter can share more about the specific salary range for the job location during the hiring process. Also, certain positions are eligible for additional forms of compensation such as bonuses and commissions. 

     

    Please note that the salary information shown below is a general guideline only and based on employees in Canada and may be different in other countries. Salaries are based upon candidate experience, qualifications, and location, as well as market and business considerations. Our pay range for Canada based candidates for this position is $90,000 -- $120,000 CAD annually. Your recruiter can share more about the specific salary range for the job location during the hiring process. Also, certain positions are eligible for additional forms of compensation such as bonuses and commissions. 

     

We’re committed to diversity and passion, and encourage you to apply, even if you don’t demonstrate all the listed skillsets! 

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. 

#LI-REMOTE

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