Data & Analytics Engineer

We are seeking an experienced and results-oriented Data & Analytics Engineer with a specialization in data engineering, extract, transform, load (ETL) processes, and advanced application integration. This role will focus on building and maintaining robust data pipelines, integrating enterprise systems, and optimizing data workflows to support business intelligence and operational efficiency. This role will be a key partner to business and analytics teams, providing critical support and collaboration to drive data-driven decision-making. Ideal candidates will have experience with analytics and reporting tools, enabling them to deliver meaningful insights and effectively address business needs. Candidate shall possess a strong technical background, willingness to engage with a side variety of business stakeholders, and a passion for designing scalable solutions.

• Data Engineering & ETL/ELT Development:
  • Design, develop, and optimize data pipelines for ETL and ELT processes to ensure efficient data movement and transformation.
  • Create reusable data models, workflows, and frameworks using tools such as SQL, Python, and Databricks.
  • Stay current with modern and scalable data engineering methodologies, continuously introducing innovative ideas and approaches to the team.
  • Develop and maintain data pipelines that integrate Databricks with ERP systems and other enterprise applications, ensuring seamless data flow and operational efficiency.
• Application Integration & ERP Optimization:
  • Lead the design and implementation of integrations between Oracle ERP, Deltek ERP, Vista Viewpoint ERP, and other business-critical systems.
  • Utilize Oracle Integration Cloud (OIC) and other middleware tools to ensure seamless data flow and process automation across applications.
  • Be proficient in utilizing APIs and capable of writing and managing scalable code that interacts with the various ERP systems within ASRC and its subsidiaries.
  • Design and implement scalable integrations between Databricks and enterprise applications.
• Data Governance & Optimization:
  • Ensure the accuracy, reliability, and security of data across systems by implementing robust governance practices.
  • Optimize data storage and retrieval processes within Oracle Databases and SQL Server Databases to enhance system performance.
  • Optimize ERP data processing and transformations within Databricks to improve reporting, analytics, and decision-making capabilities across business functions.
• Business Analysis & Collaboration:
  • Partner with stakeholders to understand business requirements and translate them into technical solutions.
  • Conduct data analysis to provide actionable insights and support data-driven decision-making processes.
  • Advanced proficiency in Excel for data analysis, reporting, and visualization, including complex formulas, pivot tables, and automation.
  • Proficient in Power BI, with the ability to create interactive dashboards, perform data modeling, and generate insights to support business decisions.
  • Document business requirements, data workflows, and integration processes to facilitate transparency, maintainability, and future scalability.
• Continuous Learning & Technical Problem-Solving:
  • Troubleshoot and resolve data engineering and application integration issues effectively and efficiently.
  • Stay abreast of the latest trends and technologies in data engineering, ETL/ELT, and application integration to continuously improve processes.
  • Embrace a growth mindset, continuously seeking opportunities to enhance skills through experimentation, research, and collaboration with peers.
  • Troubleshoot and resolve data engineering and application integration issues effectively and efficiently.
  • Proactively identify and troubleshoot complex data challenges, applying critical thinking and creative problem-solving to optimize performance and reliability.

ASRC’s Core competencies include Leading Self, Leading People and Leading the Organization. In addition to our core competency model, our framework includes competencies specific to the various levels of positions within our company. For more information on our core competencies please contact the HR Department and reference the ASRC Leadership Framework.

Customer Focus

• Is dedicated to meeting the expectations and requirements of internal and external customers; gets first-hand customer information and uses it for improvements in products and services; acts with customers in mind; establishes and maintains effective relationships with customers and gains their trust and respect.

Drive for Results

• Can be counted on to exceed goals successfully; is constantly and consistently one of the top performers; very bottom-line oriented; steadfastly pushes self and others for results.  

Problem Solving

• Uses rigorous logic and methods to solve difficult problems with effective solutions; probes all fruitful sources for answers; can see hidden problems; is excellent at honest analysis; looks beyond the obvious and doesn't stop at the first answers.

Time Management

• Uses time effectively and efficiently, concentrating his/her efforts on the more important priorities.

Required Qualifications:

• Bachelor’s degree in Computer Science, Data Engineering, Information Systems, or a related field.
• 3-5 years of experience in data engineering, ETL/ELT development, and application integration or related experience.
• Expert proficiency in SQL, Python, Databricks and other Data Engineering technology for data manipulation and process automation.
• Strong knowledge of the Kimball Method of data warehouse design and development methodology and strong expertise in Databricks and serverless SQL solutions.  Including working experience in Oracle and SQL Server Databases.
• Experience with data analysis using Excel and PowerBI

Preferred Qualifications:

• Hands-on experience with Oracle ERP, Deltek ERP, Vista Viewpoint ERP, and Oracle Integration Cloud (OIC).  Experience with data visualization tools like Power BI or Tableau.
• Advanced understanding of data architecture, data governance, and data security practices.
• Certifications in Oracle Integration Cloud, Databricks, Oracle/SQL Server Database, or related technologies.

Ability to read and interpret documents such as safety rules, operating and maintenance instructions, and procedure manuals. Ability to write routine reports and correspondence. Ability to speak effectively before groups of employees or customers.

Ability to add, subtract, multiply, and divide in all units of measure, using whole numbers, common fractions, and decimals. Ability to compute rate, ratio, and percent and to draw and interpret bar graphs.

Ability to apply common sense understanding to carry out instructions furnished in written, oral, or diagram form. Ability to deal with problems involving several concrete variables in standardized situations.

The physical demands described herein are representative of those that must be met by an employee to successfully perform the essential functions of this position.  Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

While performing the duties of this job, the employee is regularly required to talk or hear.  The employee is frequently required to sit; reach with hands and arms; and to use hands to finger, handle, or feel.  The employee is occasionally required to stand, walk, climb or balance.  The employee must frequently lift and/or move up to 10 pounds and occasionally lift and/or move up to 25 pounds.   Specific vision abilities required by this job includes the ability to adjust focus.

The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job.  Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

The work environment is in a busy office setting.  The noise level in the work environment is usually moderate. While performing the duties of this job, the employee may be occasionally exposed to outside weather conditions and may be required to travel in small and large commercial aircraft.

NOTE:  This document does not create an employment contract, implied or otherwise. The statements contained herein are intended to describe the principal functions of this position, the level of knowledge and skill typically required, and the scope of responsibilities, but should not be considered an all-inclusive listing of work requirements.

ASRC is a drug free workplace and pre-employment drug testing is part of the hiring process.

ASRC and its family of companies are Equal Opportunity Employer. Qualified applicants will receive consideration for employment without regard to race, color, sex, sexual orientation, gender identity, national origin, religion, disability, protected veteran status or any other legal protected status. EOE: M|F|D|V Know Your Rights: Workplace Discrimination is Illegal

Arctic Slope Regional Corporation, an Inupiat-owned corporation created as a result of the Alaska Native Claims Settlement Act.

ASRC's family of companies apply a shareholder preference in employment, to the maximum extent feasible, as authorized by law.