General information

Office (s)
Monterrey, NL
Date Published
Monday, January 17, 2022
Job ID
Information Technology

Description & Requirements

About Us:

We’re here for the hard-working businesses that keep the world turning. They’re the companies who make, deliver, and sell the things we all need. They trust Epicor to help them do business better. Their industries are our industries, and we understand them better than anyone. By working hand-in-hand with our customers, we get to know their business almost as well as they do. Our innovative solution sets are carefully curated to fit their needs and built to respond flexibly to their fast-changing reality. We accelerate every customers’ ambitions, whether to grow and transform, or simply become more productive and effective. That’s what makes us the essential partners for the world’s most essential businesses.

Job Responsibilities (which will evolve as projects progress and new needs emerge): 

  • Creates and maintains optimal data pipeline architecture on Azure platform. Ensures that system designs adhere to solution architecture design and are traceable to functional as well as non-functional requirements.
  • Leverages Azure Data Factory and Databricks to assemble large, complex data sets that meet end user and business requirements. Designs new solutions and services to improve overall user experience.
  • Identifies, designs, and implements internal process improvements such as automating manual processes and optimizing data delivery. Defines system design standards to improve and sustain standardization.
  • Builds the infrastructure required for optimal data extraction, transformation, and loading from a wide variety of data sources. Establishes standardized design and development processes to enable cost effective delivery.
  • Designs relational and non-relational data stores on Azure.
  • Builds analytical tools to provide actionable insights from key business performance metrics.
  • Assists Manager-Data Administration in leading coordination with other staff to ensure data handling meets organizational objectives for data quality, business process management, and risk management. This includes, but is not limited to, developing procedures, building analytical tools, and designing data structures.
  • Provides technical mentoring to other team members for best practices on data engineering and cloud technologies.
  • Perform all duties and maintain all standards in accordance with company policies, procedures, and internal controls such as SOX.
  • Other duties as assigned.

Required qualifications:

  • Experience working as part of IT Data team using Azure based technologies to solve business problems and build solutions.
  • Azure PaaS, Data analytics, Data warehousing and Data science.
  • Azure Spark, ADF, T-SQL Scripting, Stored Procs, Data bricks, Python
  • Azure Synapse Analytics, SQL Pool
  • Minimum of six years of data engineering experience
  • Deep knowledge of data ingestion strategies and understanding of the Data Lake and Dimensional data models within Azure.
  • Experience with the Azure storage technologies (Azure Data Lake, Azure SQL Data Warehouse, Azure SQL Database)
  • Experience with Azure data movement and transformation capabilities (Azure Data Factory, Data Lake Analytics, Data Bricks, Stream Analytics)
  • Comfortable with Microsoft SQL data technologies (SSAS/SSIS/SSRS)

Additional preferred skills:

  • Microsoft related certifications
  • Experience with visualization tools such as Tableau (preferred) or Power BI.