Data Engineer/Programmer

Every day, Global Payments makes it possible for millions of people to move money between buyers and sellers using our payments solutions for credit, debit, prepaid and merchant services. Our worldwide team helps over 3 million companies, more than 1,300 financial institutions and over 600 million cardholders grow with confidence and achieve amazing results. We are driven by our passion for success and we are proud to deliver best-in-class payment technology and software solutions. Join our dynamic team and make your mark on the payments technology landscape of tomorrow. At ACTIVE Network, we are building solutions for all types of activity organizations helping them automate, simplify and grow their businesses. Our cloud technology powers business events, community programs, parks departments, local attractions, faith-based organizations, sports events, and outdoor activities. We deliver technology that changes the way the world gets active. Job Description We are looking for a skilled and experienced Data Engineer to join our team As a Data Engineer, you will be responsible for data preparation jobs, data analysis and data reporting. You will be responsible for performing technical troubleshooting and providing technical expertise for ETL jobs. The job role might also require you to learn new tools and technologies fast, and you should have in-depth database knowledge as well as basic programming and scripting skills. You will help to build efficient and stable data pipelines which can be easily maintained in the future. You should have expertise in the design, creation, management, and business use of large datasets and databases. Responsibilities Developing and implementing ETL processes Developing and maintaining integration tools and utilities Design table structures, developing stored procedures, views, etc and troubleshooting issues across different applications Develop, maintain and troubleshoot SSRS reports Performing root cause analysis and providing recommendations for resolution Design, implement, and continuously expand data pipelines by performing extraction, transformation, and loading activities Gather requirements and business process knowledge in order to transform the data in a way that’s geared towards the needs of end users Maintain and improve already existing processes Ensure that the data architecture is scalable and maintainable Work with the business in designing and delivering correct, high quality data Investigate data to identify potential issues within ETL pipelines, notify end-users and propose adequate solutions Prepare documentation for further reference Skills and Qualifications Minimum of 4 years of experience in ETL development Knowledge of ETL concepts, tools and data structures Ability to perform complex data analysis and troubleshooting Excellent verbal and written communication skills Ability to work independently Strong problem-solving skills Expert level SQL knowledge (query performance tuning, index maintenance, etc.) as well as an understanding of database structure and good design practices Knowledge of at least one ETL tool (SSIS, CloverDX, Informatica, etc.) Knowledge of various SQL data storage mechanisms and Big Data technologies a plus Passionate about complex data structures and problem solving Ability to pick up new data tools and concepts quickly Experience parsing, scripting data from text based or non-uniform data sets. Preferred: Linux and shell scripting a strong plus Expert level CloverDX experience, graphs, subgraphs, Job flows, scripting, etc. 7+ years experience working with complex SQL, procedures and ETL data projects Able to work with unstructured data files ACTIVE Network Perks & Benefits Great Working Environment “5+1” Endowment Insurance; Medical Insurance; Unemployment Insurance; work-related injury insurance and Childbirth Insurance. Housing Accumulation Funds Commercial Medical Insurance in addition to the Government’s required medical insurance (family members can be added to account) 15 Days PTO (Paid Time off) per year in addition to all the public holidays Flexible Working Schedules (projects based) Monthly Birthday Celebration for Employees ACTIVEx Day ACTIVE Kids Day for ACTIVE’s Generation Global Payments Inc. is an equal opportunity employer. Global Payments provides equal employment opportunities to all employees and applicants for employment without regard to race, color, religion, sex (including pregnancy), national origin, ancestry, age, marital status, sexual orientation, gender identity or expression, disability, veteran status, genetic information or any other basis protected by law. Those applicants requiring reasonable accommodation to the application and/or interview process should notify a representative of the Human Resources Department. #J-18808-Ljbffr