Senior Data Engineer

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

Salary Range:

$105,500.00 - $194,500.00

Position: Senior Data Engineer

Location: San Leandro, CA - Hybrid

Benefits: Competitive salary; 20 Vacation days with increase for time served; high quality healthcare; 401(k) with 6% employer match; FSA and supplemental insurance; paid parental leave; 3 days paid volunteering; summer Fridays; flexible lifestyle benefits (fitness/tuition reimbursement)

Join AVEVA as a Senior Data Engineer and become an integral part of our innovative and collaborative R&D DevOps and Data Insights team. Your expertise will empower us to harness the power of data to drive insights, optimization, and innovation across our organization. Together, we will create a more accessible and efficient big data ecosystem that propels AVEVA to new heights.

As a Senior Data Engineer, you will design and implement data pipelines to integrate information from diverse source systems across R&D software development platforms. By consolidating, cleansing, and structuring data for use in analytics and reporting applications, particularly Microsoft's Power BI, you will make data easily accessible to stakeholders and internal customers. Your excellent communication skills, adaptability, and commitment to collaboration will ensure your success in this role.

Responsibilities:

• Design and implement end-to-end data collection, intake, and processing systems.
• Develop data pipelines to integrate data from various systems seamlessly.
• Optimize data structures and organization for specific reporting needs.
• Leverage ETL tools and REST-oriented APIs to create and manage data integration jobs.
• Translate end-user requirements into technical implementation with a focus on Power BI development.
• Design and maintain efficient data models, schemas, and database structures for optimized storage.
• Create prototypes and mockups to facilitate collaborative decision-making.
• Manage Power BI Services deployment pipelines and workspace management.
• Work with diverse data sources, including Cosmos DB, Excel, SQL Server, Azure SQL, SharePoint Lists/Libraries, and Azure DevOps REST APIs.
• Implement change management and source control for Power BI reports.
• Maintain a general understanding of Azure DevOps work management and CI/CD processes related to Power BI.

Essential Skills:

• Proven experience in end-to-end data collection, intake, and processing.
• Demonstrated ability to build data pipelines and integrate data from various systems.
• Aptitude for structuring and organizing data for specific reporting needs.
• Strong understanding of ETL tools and REST-oriented APIs for creating and managing data integration jobs.
• Ability to translate end-user requirements into technical implementation with a focus on Power BI.
• Experience designing and maintaining efficient data models, schemas, and database structures for optimized storage.
• Proficiency in designing prototypes and mockups.
• Familiarity with various data sources, including Cosmos DB, Excel, SQL Server, Azure SQL, SharePoint Lists/Libraries, and Azure DevOps REST APIs.
• General understanding of Azure DevOps work management and CI/CD processes related to Power BI.

Desirable Skills

• Experience with Microsoft Azure Data Factory for designing collection pipelines.
• SQL T-SQL experience writing SPs and Views.
• Knowledge of data security best practices.
• Experience working with Cosmos DB for data storage and retrieval.
• Familiarity with datamart design and implementation.
• Experience with SQL Server Integration Services (SSIS) for data integration and transformation.
• Proficiency in SQL Server Reporting Services (SSRS) for report generation and management.

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.

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