Senior Data Warehouse Engineer

3 weeks ago

Little Chute, United States Heartland Business Systems Inc Full time

Job Type

Full-time

Description

Position Summary:

This position requires a candidate with a strong technical background in developing and delivering BI solutions along with a strong understanding of SQL Server environments. Business intelligence (BI) is a set of technologies and practices for transforming business information into actionable reports and visualizations.

A Senior Data Warehouse Engineer is the data professional who assists with the design of, and prepares, the data infrastructure to be leveraged by the HBS BI Data Developers. This individual will design, build, and integrate data from various resources. In addition, this individual ensures the operations of the data pipeline follow a consistent process of Ingestion, Processing, Storage and Access. The work involves tuning databases for fast analysis and creating table schemas.

The Senior Data Warehouse Engineer is responsible for making data easily accessible, ensuring the process works smoothly and is optimized. This individual is a critical firm member of the Data Team. This role will run Extract, Transform and Load (ETL) on top of datasets and create data that is warehoused to be used for reporting and analysis.

Roles and Responsibilities/ Essential Functions:

  • Meet with internal customers to understand current business processes and business needs to provide data driven solutions.
  • Support and administer the underlining infrastructure and layout of HBS's data environment including continued architecture and maintenance of warehouse solution.
  • Optimize the data collection process.
  • Develop policies and procedures for the collection and analysis of data.
  • Review data sources to ensure integrity of the data and recommend/implement data integrity solutions.
  • Collaborate with the internal data team to ensure the requirements are being met to build the right solution to solve the right problem.
  • Estimate development effort required to deliver data needs and requests.
  • Manage and build system and data integration through API's.
  • Use business analysis skillset to identify development needs for the purpose of streamlining and improving the operations of the organization for efficiency and profitability.
  • Work as part of the operations team to continue to grow and mature data services and delivery options for HBS.
  • Based on experience, one may mentor other engineers in developing scalable, secure, high-performance BI and Data solutions.
Requirements

Competencies:
  • Accuracy - Able to produce high quality work deliverables leveraging industry best practices.
  • Analytical Skills - Effectively interprets business needs and translates them into application and operational requirements, resolving complex technical and business problems.
  • Communication - Strong written, verbal, and non-verbal communication skills, especially conveying complex information in an understandable manner.
  • Leadership - Motivates and guides others to ensure performance is in accordance with clear expectations and goals.
  • Learning - Quickly learns new technologies / processes required to deliver advanced solutions.
  • Presentation Skills - Effectively conducts formal and informal presentations in both small and large group settings at all levels of a company.
  • Project Management - Understands process (re-)engineering, planning, organizing, staffing, directing, and controlling work tasks.
  • Time Management - Effectively prioritizes and utilizes available time for managing multiple tasks/projects simultaneously.
Required Experience:
  • Minimum of 6 years progressive experience delivering data solutions.
  • Experience with needs analysis, software evaluation and selection, customization, and implementation.
  • Data Warehousing systems and architecture experience in 'real world', practical, successful implementations.
  • Understand multi-dimensional database structures and schemas.
  • Strong knowledge of system design, development, and deployment.
  • Microsoft BI Suite Experience:
  • Microsoft Excel
  • Microsoft SQL Server Integration Services (SSIS)
  • Microsoft SQL Server Reporting Services (SSRS)
  • Microsoft SQL Server Analysis Services (SSAS)
  • Programming and Processing Experience:
  • T-SQL
  • ETL
  • Azure Experience:
  • Azure SQL Database
  • Azure SQL Manage Instance
  • Azure Architecture
  • Azure Data Factory
  • Strong knowledge of SQL utilizing MS SQL Server
Preferred Experience:
  • SWE or equivalent experience in prior role.
  • Experience using and building API's
  • Reverse ETL
  • Python
  • SMART Connect
  • Experience in a Technology Service Provider business model.
  • PowerShell knowledge and understanding
  • Understanding of report writing and visualization
  • Microsoft BI Suite Experience
  • Microsoft Power BI
  • Microsoft certified: Data Analyst Associate
  • Microsoft certified: DP-200 - Implementing an Azure Data Solution
  • Microsoft certified: DP-201 - Designing an Azure Data Solution
  • Microsoft certified: DP-300 - Administering Relational Databases on Microsoft Azure
Required Skills, Education and/ or Certifications:
  • Bachelor's degree in business or IT related discipline

Equal Opportunity Employer - Including Disabled and Veterans

#HBS

  • Senior Consulting Engineer- Little Chute

    2 weeks ago

    Little Chute, United States Experis Full time

    Our end-client located in WI is searching for Senior Consulting Engineers in SW and NE Wisconsin! Should you be interested, or know of anyone in the IT market and interested, apply today orplease contact Jenny or Sadie at Jennifer.Wilhelm@Experis.com // Sadie.McQuade@Experis.com with additional questions and information! Title: Senior Consulting Engineer ...

  • Senior Consulting Engineer

    1 week ago

    Little Chute, United States Heartland Business Systems Inc Full time

    Job Type Full-time Description Position Summary: The Consulting Engineer is responsible for designing, implementing, and supporting advanced multiplatform solutions to Heartland's customers. Roles and Responsibilities/ Essential Functions: Work as a member of the HBS engineering team providing consultative and proactive project management support to HBS'...

  • Senior Consulting Engineer

    7 days ago

    Little Chute, United States Heartland Business Systems Inc Full time

    Job Type Full-time Description Position Summary: The Consulting Engineer is responsible for designing, implementing, and supporting advanced multiplatform solutions to Heartland's customers. Roles and Responsibilities/ Essential Functions: Work as a member of the HBS engineering team providing consultative and proactive project management support to HBS'...

  • Data Scientist, Senior Manager

    6 days ago

    Little Rock, United States Karkidi Full time

    Play a key role as part of Dolby's new R+D Center in Bangalore as a Senior Research Leader in our Advanced Technology Group ATG. ATG is the research and technology arm of Dolby Labs. It has multiple competencies that innovate on technologies in audio, video, AR/VR, multimodal applied to gaming, music, professional, broadcast and user-generated content. Many...

  • Director, Warehouse Operations

    4 weeks ago

    Little Ferry, United States CCG Marketing Solutions Full time

    Job Description Job Description Company Overview: CCG is a dynamic and rapidly growing company delivering a single source supply chain partnership for business to business, direct to consumer, and direct to practitioner distribution. We have vertically integrated from concept to multi-channel distribution the ideation, technology, custom sourcing, branded...

  • Director, Warehouse Operations

    4 weeks ago

    Little Ferry, United States CCG Marketing Solutions Full time

    Job DescriptionJob DescriptionCompany Overview:CCG is a dynamic and rapidly growing company delivering a single source supply chain partnership for business to business, direct to consumer, and direct to practitioner distribution. We have vertically integrated from concept to multi-channel distribution the ideation, technology, custom sourcing, branded...

  • Senior NonStop Engineer

    1 day ago

    Little Rock, United States Fiserv Full time

    Fiserv Senior NonStop Engineer Little Rock , Arkansas Apply Now Calling all innovators – find your future at Fiserv. We’re Fiserv, a global leader in Fintech and payments, and we move money and information in a way that moves the world. We connect financial institutions, corporations, merchants, and consumers to one another millions of times a day –...

  • Design engineer Junior/Medior/Senior

    2 weeks ago

    Little Rock, United States Infranea Full time

    Do you share our passion for information engineering? At Infranea, we are passionate about infrastructure, Digital Engineering & Services and Process & Contracts of complex infrastructure works. This is how we contribute to the digital transformation of the construction industry. Our 90 engineers and consultants design, integrate, visualise and simulate all...

  • New CNAs

    1 month ago

    Little Chute, United States Ascension Full time

    Ascension has provided thousands of associates and caregivers a rewarding career in healthcare since 1902. We strive to expand access to high-quality, low-cost, person-centered care and services for all. At Ascension Medical Group at Little Chute Anticoagulation, caregivers can find both a jumpstart to their careers and clinical education opportunities. If...

  • New CNAs

    3 days ago

    Little Chute, United States Ascension Full time

    Ascension has provided thousands of associates and caregivers a rewarding career in healthcare since 1902. We strive to expand access to high-quality, low-cost, person-centered care and services for all. At Ascension Medical Group at Little Chute Family Practice, caregivers can find both a jumpstart to their careers and clinical education opportunities. If...

  • New CNAs

    1 week ago

    Little Chute, United States Ascension Full time

    Ascension has provided thousands of associates and caregivers a rewarding career in healthcare since 1902. We strive to expand access to high-quality, low-cost, person-centered care and services for all. At Ascension Medical Group at Little Chute Imaging, caregivers can find both a jumpstart to their careers and clinical education opportunities. If you are...

  • Caregiver / CNA / New CNA Grads (We Will Train) - Ascension Medical Group at Little Chute

    4 weeks ago

    Little Chute, United States Ascension Full time

    Ascension has provided thousands of associates and caregivers a rewarding career in healthcare since 1902. We strive to expand access to high-quality, low-cost, person-centered care and services for all. At Ascension Medical Group at Little Chute, caregivers can find both a jumpstart to their careers and clinical education opportunities. If you are looking...

  • Warehouse Associate

    4 weeks ago

    North Little Rock, United States Farmer Brothers Full time

    Job DetailsLevel Entry Job Location 36-Little Rock - Little Rock, AR Position Type Full Time Education Level High School or GED Travel Percentage Local Driving Required Job Shift Day Job Category Warehouse Description The Warehouse Associate is responsible for performing a variety of warehouse duties, including receiving, shipping, order picking, and...

  • Senior Manager, Software Engineering

    2 days ago

    Little Rock, United States Walmart Full time

    Position Summary... What you'll do... Do you love building and pioneering in the technology space? Do you enjoy? solving complex business problems in a fast-paced, collaborative,inclusiveand iterative delivery environment? At Walmart, you’ll be part of a big group of makers, breakers, doers and disruptors, who love to solve real problems and meet real...

  • Power System Operations Engineer III/Senior

    4 weeks ago

    Little Rock, United States Misoenergy Full time

    If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process. Power System Operations Engineer III/Senior Active - Full Time Employee -SE Little Rock, AR, US 2 days ago Requisition ID: 2387 MISO offers a comprehensive benefits package available on your first day of...

  • Power System Operations Engineer III/Senior

    1 week ago

    Little Rock, United States Midcontinent Independent System Operator Full time

    MISO offers a comprehensive benefits package available on your first day of employment. Position Location: Little Rock, AR Are you an electrical engineer looking to make an impact in a control room that oversees the reliable operations of an electric grid serving 45 million people? Do you have interest in working in a fast-paced environment where you will be...

  • Senior Electrical Engineer

    7 days ago

    Little Rock, United States MIDCONTINENT INDEPENDENT SYSTEM OPERATOR INC Full time

    Job DescriptionJob DescriptionMISO offers a comprehensive benefits package available on your first day of employment.Position Location: Carmel, IN; Eagan, MN; or Little Rock, ARAre you an electrical engineer with an interest in joining a great team that is preparing the big picture for real-time success, collaborating with business units focusing on the...

  • Data Systems Intern

    7 days ago

    Little Rock, United States Arkansas Foodbank Full time

    Position Summary The Arkansas Foodbank is the state's largest non-governmental provider of emergency food aid. We assist people in 33 counties across central and southern Arkansas. The Arkansas Foodbank operates as a distribution hub for over 450 partner agencies in 33 counties in central and south Arkansas. These agencies include food pantries, soup...

  • Data Systems Intern

    2 weeks ago

    Little Rock, United States Arkansas Foodbank Full time

    Position Summary The Arkansas Foodbank is the state's largest non-governmental provider of emergency food aid. We assist people in 33 counties across central and southern Arkansas. The Arkansas Foodbank operates as a distribution hub for over 450 partner agencies in 33 counties in central and south Arkansas. These agencies include food pantries, soup...

  • Senior Electrical Engineer

    3 weeks ago

    Little Rock, United States oilandgas.org.uk Full time

    JOB DESCRIPTION Wood is recruiting Senior Electrical Engineers on a contract basis - for present and up-coming projects in Staines. We are the world's engineers, the company that makes the world a better place, the company that delivers the change the world needs most, and the company that doesn't just talk sustainability but makes it real for our clients...