Skip Navigation

Sr. Data Warehouse Engineer (Program / Analyst) at Epicor | Software Careers

Search

or match your skills with LinkedIn

LinkedIn - job matching tool
Apply now Job ID 19001679 Date posted Nov. 07, 2019 Austin, Texas; Minneapolis, Minnesota; Carlsbad, California; Dublin, California Information Services

Sr. Data Warehouse Engineer (Program / Analyst)


About Us:

Epicor Software is a global technology leader dedicated to helping businesses drive growth for more than 45 years. Our modern, industry-specific software helps customers boost efficiency and productivity by simplifying and automating everyday processes. We have a stellar team of nearly 4,000 worldwide employees who are passionate about building exceptional products and solutions through teamwork, constant innovation, and integrity. We strive to hire and reward star players who inspire one another and drive results for the business and our customers.

About the Role:

This position is responsible for supporting day-to-day data warehouse operations, maintaining corporate and IT procedures and standards, and data warehouse optimization on a global basis supporting the Epicor Data Analytic Platform (EDAP) for enterprise data warehouse. The Data Warehouse Engineer will be supporting internal data warehouse development and sustainment for the enterprise data warehouse including EDAP DW projects and deployments, support of Epicor international users, and the opportunity to design, develop and implement technology solutions to meet current and future data warehousing and reporting needs.

What You’ll Do:
  • Design, develop, and utilize SQL codes, data pipelines, Azure Data Factory and SSIS.
  • Perform daily monitoring and administrative tasks for all data warehouse pipelines and packages.
  • Optimize data pipelines performance through proactive maintenance.
  • Maintain enterprise data warehouse, services, and ETL processes proactively.
  • Perform specialized data investigations to support analytics and reporting scenarios.
  • Build cross functional relationship with business intelligence teams to understand their requirements and data needs.
  • Migrate and/or upgrade data warehouse database platform and versions.
  • Participate in the change control process to implement both planned and unplanned migrations through application environments.
  • Work closely with application and systems administrators on current production system changes or upgrades.
  • Assist Tier 2/3 problem support and change control.
  • Assist with the data recovery from system or application crashes.

What You Need to Succeed:
  • Degree in Computer Science or equivalence.
  • Experience managing mid to large scale database development and sustainment.
  • Experience with SQL development, business intelligence tools such as SSIS, SSRS, and dashboards.
  • Hands on technical knowledge with Azure Data Factory, Azure DW and Azure cloud solution
  • 3-4 years of experience with SQL Server database development and technologies.
  • 3 years of experience with Azure Data Warehouse and Azure Data Factory.
  • The ideal candidate is expected to stay abreast and incorporate emerging technologies and new design approaches as well as the following skills:
  • Strong working knowledge with MS SQL Server technology and SSIS.
  • Strong working knowledge with Azure DW and Azure Data Factory.
  • Understanding of Business Intelligence and analytics platform.
  • Understanding of financial data desired.
Additional Skills That Could Set You Apart:
  • Good communication skills to develop methodology which provides for timely status of the Enterprise Database Warehouse and sets expectations with the business and IT management on quality and timing of DW processes being implemented.
  • Good verbal and written skills to develop data warehouse architecture and effectively communicate the benefits to the IT and business when necessary.
  • Ability to effectively translate internal customer needs into technical solutions
  • Strong analytical skills
  • Understand the importance of mission critical information systems.
  • Be able to work as a team and interact professionally.

Primary location: Austin Texas United States
Other location(s): US-Minnesota-Minneapolis;US-California-Dublin;US-California-Carlsbad
Sr. Data Warehouse Engineer (Program / Analyst)

What’s around You

Restaurants, bars, gyms and more. Take a look at the map to see what’s nearby.

Join our talent community

Sign Up For Job Alerts

Get ahead of the game–join our Talent Community and be the first to hear about new Epicor job opportunities.

Interested InSelect a job category from the list of options. Select a location from the list of options. Finally, click “Add” to create your job alert.

  • Information Services, Austin, Texas, United StatesRemove
  • Information Services, Minneapolis, Minnesota, United StatesRemove
  • Information Services, Carlsbad, California, United StatesRemove
  • Information Services, Dublin, California, United StatesRemove

Or

By submitting my CV / resume or signing up for job alerts I agree to receive phone or email communications from Epicor and its subsidiaries about Epicor employment opportunities as they may arise. I understand that Epicor’s Privacy Policy will apply and that I may withdraw my consent to these communications at any time.