Beacon Technologies is seeking an ETL Developer for our client partner. We are currently looking for an ETL Developer that works directly with business users to develop data pipelines from source applications to corporate data platforms (Data Warehouse/Lake) and optimize analytic solutions. This position will utilize tools such as Informatica, SQL and Python to create integrations or modify current integrations for various projects that are handed off to the Data and Analytics Services group.

Primary Accountabilities:

• Develops scalable, innovative solutions for extracting, transforming, and moving data.
• Performs data profiling and data analysis to assist in understanding the data.
• Optimizes data models through normalization, table analysis and review of queries.
• Presents outcomes of analytic models in a format easily understood by the business.
• Performs ETL/ELT functions for new or existing sources.
• Conducts requirements gathering with business stakeholders and users to plan a roadmap of project activities.
• Works with the business to assess the validity of the data and achieve minimum levels of quality.
• Gathers and compiles data using various data collection techniques in response to data requests.
• Creates code or GUI data mappings while following company data standards and approaches.
• Collaborates with others responsible for pipeline development.

Required Experience:

• 5 years of direct experience in a related field (coding, ETL Development/Engineering, analytics, or research).
• Experience with Informatica ETL/ELT tools, specifically IDMC/Informatica Cloud, PowerCenter, BDM/DEI products.
• Proficiency in SQL required.
• Experience working with Snowflake Data Platform.
• Working knowledge of Python as it relates to developing ETL/ELT pipelines.

Preferred Experience:

• Experience in working with diverse data sources including APIs, Oracle, SQL Server and Flat Files.
• Data Modeling experience utilizing Erwin Data Modeling tool.
• Experience with Tidal Job Scheduling Software.
• Development experience with Workday and/or HR domain data.

About Beacon Technologies

Are you looking to advance your career in information technology? Beacon Technologies offers career advancement opportunities, extensive training, and excellent benefits including paying for health and dental premiums for salaried employees. In addition to providing interesting opportunities, Beacon Technologies provides that old fashioned, personal touch, so you feel like a part of the Beacon team.

Beacon Technologies, Inc. is an equal employment opportunity employer with a functioning Affirmative Action Plan. It is the policy of Beacon Technologies, Inc. to ensure equal employment opportunity without discrimination or harassment on the basis of race, color, religion, sex, sexual orientation, gender identity or expression, age, disability, marital status, citizenship, national origin, genetic information, ethnicity, ancestry, disability, medical condition, military and veteran status, or any other characteristic protected by law. Beacon Technologies, Inc. prohibits any such discrimination or harassment.