ETRM Solutions Architect

ETRM Azure Solutions Architect

Senior Manager, ETRM Solution Architect This is a hands-on, ETRM Solutions Architect opportunity within our North American team. This position will collaborate within a team of technologists to produce enterprise scale data platforms for our clients' needs. Our teams work on the latest data technologies in the Azure space including Azure Synapse, Data Lake, Data Bricks, Spark, etc.

Primary Responsibilities:

• Owning the technical solution and ultimate success of capabilities.
• Defining implementation architectures, developing a deep expertise in both business process and employed technologies, and obtaining a broad know-how around the existing application and service landscape.
• Being a subject matter expert on areas as they related to customers, agents, and internal employee applications. This includes data modelling, star schema design, ETL development, etc.
• Ensure all deliverables are of high quality throughout the project by adhering to coding standards and best practices and participating in code reviews.
• Participate in integrated test sessions of components and subsystems on test and production servers.
• Serve as an architect and provide guidance during software development life cycle to solve business issues through the process of identifying and analyzing detailed requirements that translate into data integration and database system designs.
• Solve business issues through the process of identifying and analyzing detailed requirements that translate business requirements into technical system designs.

Required

Skills and Experience:

• ETRM expertise required
• 10+ years in a data engineering role with demonstrable experience with data integration and data warehouse projects.
• Experience in column-oriented database technologies (i.e. Synapse, Big Query, Redshift, Vertica, etc.) and traditional database systems (SQL Server, Oracle, MySQL, etc.)
• Experience in data integration automation via Azure Data Factory
• Experience architecting solutions in the cloud. Must have deep knowledge in data technologies in Azure
• Experience with Client and/or AI services (i.e. Azure Client, Tensorflow, etc.)
• Experience with data modeling, warehouse design, and fact/dimension concepts.
• Experience architecting and building data marts, warehouses, etc.
• Experience working with different query languages (i.e. PL-SQL, T-SQL)