Sr. Data Engineer

  • Meridian, ID
  • Posted 41 days ago | Updated 6 hours ago


On Site
Full Time


IT management
Data Analysis
Business analytics
Cross-functional team
Data processing
Microsoft SQL Server
Order processing
IT architecture
Business operations
Data quality
Meta-data management
Data profiling
Dimensional modeling
Star schema
Data loading
Snow flake schema
Amazon Redshift
Business intelligence
Microsoft Power BI
Business Objects
Web intelligence
Cloud computing
Amazon S3
Data engineering
Programming languages
Amazon Web Services
Data manipulation
Data modeling
Data warehouse
Data Lake
Microsoft SSIS
Red Gate
Critical thinking
Problem solving
Analytical skill
IT service management
Oracle Application Express

Job Details

Job#: 2032984

Job Description:

Our client is looking for a Data Engineer to provide innovative modernization and ensure the availability, reliability, and performance within their Data Analytics eco-system.

What You Will Do:
  • Serve as part of our Data Engineering and Analytics team, providing data analytics capabilities for various Business partners and customers
  • Influence and evangelize analytical methodologies to support business partner's needs
  • Act as a technical lead for designing and implementing custom reports and dashboards
  • Assess requirements and assist with developing data eco-system infrastructure
  • Solve complex business problems through data analysis and providing data-driven solutions that help drive the business forward
  • Interface with data analysts to define and implement data requirements to meet their analytic needs
  • Participate in the design and build of conceptual, logical, and physical data models to support business analytics
  • Recommend data strategies, ETL processes, and procedures for getting data in and out of the data warehouse and data lake
  • Design, build, test, and maintain reliable pipelines to move and transform data accurately based on architectural standards
  • Create cloud-based solutions and processes that enable data and information workers
  • Ensure that the performance and cost of the data environment is optimized for the organization
  • Cultivate cross-functional team and department collaborative relationships
  • Design, develop, and maintain data processing in SQL Server/Snowflake
  • Build required infrastructure for efficient extraction, transformation, and loading of data from various data sources using SQL technologies
  • Work with collaborators, including data, design, and product teams, and assist them with data-related technical issues
  • Support the data infrastructure needs of collaborators, including the Product, Data, and Design teams, while assisting with data-related technical issues
  • Test reporting solutions and provide training
  • Interact with technical resources from various teams within the IT department to define and test technical changes to the system
  • Design and implement custom reports and dashboards
  • Translate analytical program models, including but not limited to scripting, error handling, and documentation
  • Work with users from various functional areas (sales, order processing, shipping, logistics, credit, finance, marketing, etc.)
  • Analyze processes ensuring sustainability, supportability, and automation
  • Identify new data from additional internal or 3rd party systems and transform it to work cohesively within existing data warehousing models
  • Participate in evaluating new technologies to ensure data and technology architecture advancement within the organization's Data eco-system
  • Identify development needs to improve and streamline business operations
  • Provide stakeholders with quality data so the business can make sound, data-driven decisions, and recommendations
  • Coach and mentor less experienced engineers
  • Perform all other assigned tasks and requirements as needed

Were Looking For:
  • Bachelor's degree in business, Business Intelligence, Data Warehouse or data related field or equivalent related experience
  • 5 years of data warehouse/BI engineering/data engineering experience and/or 3 years of BI experience
  • Experience in data access and delivery technologies, including familiarity with data quality assessment, data organization, metadata, and data profiling
  • Ability to take complex, ambiguous problems, break them down into smaller parts, and problem solve to come up with a whole, integrated, and strategic solution
  • Significant knowledge of and experience with best practices for data modeling, dimensional modeling (Star schema), data ingestion, queries, and data loading options
  • Wide experience of cloud data technologies such as Snowflake and RedShift
  • Significant experience with BI tools such as AWS QuickSight, Power BI, R, Python, SAP Business Objects and Web Intelligence (WEBI) reporting tools, and other visualization tools
  • Significant experience with AWS Services like Cloud Formation, S3, Glue, State Machine, Lambda, Event Bridge, SNS and Appflow
  • Ability to self-learn and lead teams into new technologies and engineering methods
  • Ability to solve technical problems relevant to data engineering using programming languages (SQL and Python)
  • Demonstrate the ability to solution with AWS services and provision infrastructure from code/template
  • Excellent data manipulation and analysis skills
  • Excellent skills in SQL, data modeling, data warehousing, data lake, and OLAP
  • Excellent written and oral communication skills
  • Experience in SSIS and SAP BODS
  • Experience with SAP systems including table structure, field definitions, CDS views and usage, a plus
  • Experience with git, a plus
  • Experience with Redgate Flyway, a plus
  • Familiarity with Agile Framework
  • Advanced critical thinking, problem solving, and analytical skills

EEO Employer

Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at or .

Apex Systems is a world-class IT services company that serves thousands of clients across the globe. When you join Apex, you become part of a team that values innovation, collaboration, and continuous learning. We offer quality career resources, training, certifications, development opportunities, and a comprehensive benefits package. Our commitment to excellence is reflected in many awards, including ClearlyRated's Best of Staffing in Talent Satisfaction in the United States and Great Place to Work in the United Kingdom and Mexico.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

About Apex Systems