Data Engineer

Philadelphia, PA, United States

AVEVA is a global leader in industrial software. Our cutting-edge solutions are used by thousands of enterprises to deliver the essentials of life – such as energy, infrastructure, chemicals and minerals – safely, efficiently and more sustainably. We’re the first software business in the world to have our sustainability targets validated by the SBTi, and we’ve been recognized for the transparency and ambition of our commitment to diversity, equity, and inclusion. We’ve also recently been named as one of the world’s most innovative companies. If you’re a curious and collaborative person who wants to make a big impact through technology, then we want to hear from you! Find out more at https://www.aveva.com/en/about/careers/. Data Engineer As a Data Engineer working with Power BI, you will be responsible for designing, building, and maintaining data pipelines to support the needs of our business intelligence team. You will work closely with data analysts and data scientists to ensure that our data is of the highest quality and is easily accessible for reporting and analysis. To be successful in this role, you should have a strong background in data engineering and experience working with Power BI. You should be comfortable working with large datasets, writing SQL queries, and creating data pipelines using tools such as Azure Data Factory. You should also have excellent problem-solving skills and the ability to work effectively in a fast-paced, dynamic environment. Responsibilities Designing and implementing data pipelines to extract, transform, and load data from a variety of sources into our Power BI data model

Ensuring the reliability and performance of our data pipelines through testing, monitoring, and optimization

Ensuring the quality of the data from Marketo through regular checks and clean up as needed

Working with data analysts and data scientists to understand their data needs and help them access and prepare data for analysis

Developing and maintaining documentation for our data pipelines and data model

Collaborating with cross-functional teams to identify and prioritize data-related projects and initiatives

Skills & Qualifications Technical skills: Strong knowledge of data engineering principles and best practices.

Experience working with Power BI and other marketing analytics tools such as Google Analytics, Adobe Analytics, or Salesforce Marketing Cloud.

Proficiency in SQL and experience writing complex SQL queries for marketing data.

Familiarity with ETL tools such as Azure Data Factory, SSIS, or Informatica for marketing data.

Knowledge of data warehousing concepts, such as data modeling, schema design, and dimensional modeling for marketing data.

Experience with data integration, data quality, and data governance for marketing data.

Experienced in data engineering or a related field with a focus on marketing data.

Communication and collaboration skills: Ability to work effectively with cross-functional teams, including marketing analysts, data scientists, and business stakeholders.

Strong communication skills and the ability to explain technical concepts to non-technical audiences for marketing analytics.

Experience developing and maintaining documentation for data pipelines and data models for marketing data.

Salary Range: $124,500.00 - $207,700.00 This pay range represents the minimum and maximum compensation that the position offers, and final compensation can vary within the range depending on work location, job experience, skills, and relevant educational attainment and/or training. USA Benefits: Competitive salary; high quality healthcare; 401(k) with 6% employer match; FSA and supplemental insurance; paid parental leave; 20 days PTO with increase for time served; 7 days of sick time; 3 days paid volunteering; flexible lifestyle benefits (commuter plans, backup care, emergency leave and fitness/education reimbursement opportunities) AVEVA requires all successful applicants to undergo and pass a comprehensive background check before they start employment. Background checks will be conducted in accordance with local laws and may, subject to those laws, include proof of educational attainment, employment history verification, proof of work authorization, criminal records, identity verification, credit check. Certain positions dealing with sensitive and/or third party personal data may involve additional background check criteria.

AVEVA is an Equal Opportunity Employer. We are committed to being an exemplary employer with an inclusive culture, developing a workplace environment where all our employees are treated with dignity and respect. We value diversity and the expertise that people from different backgrounds bring to our business. AVEVA provides reasonable accommodation to applicants with disabilities where appropriate. If you need reasonable accommodation for any part of the application and hiring process, please notify AVEVA at [email protected] . Determinations on requests for reasonable accommodation will be made on a case-by-case basis.

Come and join AVEVA to create the transformative technology that enables our customers to engineer a better world.

#J-18808-Ljbffr