Home
Jobs
Saved
Resumes
Senior Data Engineer at Heartland Business Systems | JobVerse
JobVerse
Home
Jobs
Recruiters
Companies
Pricing
Blog
Jobs
/
Senior Data Engineer
Heartland Business Systems
Website
LinkedIn
Senior Data Engineer
Springfield, Missouri, United States of America
Full Time
1 hour ago
No H1B
Apply Now
Key skills
Azure
ETL
MS SQL Server
MySQL
Oracle
Postgres
SQL
SSIS
PowerShell
Data Warehousing
BI
Power BI
Azure SQL
PostgreSQL
SQL Server
GitHub
Sales
About this role
Role Overview
Transform data into a useful format for analysis and focus on design and architecture.
Prepare the data infrastructure for BI Data Developers.
Design, build, integrate data from various resources and manage big data.
Ensure the operations of the data pipeline follow a consistent process of Ingestion, Processing, Storage and Access.
Tune databases for fast analysis and create table schemas.
Make data easily accessible, ensuring smooth and optimized processes.
Run Extract, Transform and Load (ETL) on datasets and create data warehouses for reporting and analysis.
Meet with clients to understand their current business processes and provide consulting services on how to build or grow data strategy.
Work with HBS Sales Solutions consultants to identify and grow opportunities within HBS client environments.
Support and administer the underlying infrastructure of a client data environment.
Develop and design the customer data collection process.
Develop policies and procedures for collection and analysis of data.
Collaborate with BI Data Developers to ensure requirements are met for the right solution.
Requirements
7+ years of experience in technology related role
Data Model Design (Physical or Conceptual or both)
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/relational database structures and schemas.
Strong knowledge of system design, development, and deployment
Microsoft BI Suite Experience (Excel, Microsoft SQL Server Integration Services (SSIS), Azure Data Factory (ADF), etc.)
Programming and Processing Experience (T-SQL, ETL, etc.)
Azure Experience in Azure SQL Database or Azure SQL Managed Instance
Strong knowledge of SQL utilizing MS SQL Server
Expertise in Professional Services or similar client facing roles
Preferred Experience: Experience in multiple industry (Education, Healthcare, Retail, Manufacturing) verticals.
PowerShell knowledge and understanding.
Understanding of report writing and visualization.
GitHub Copilot experience.
Microsoft BI Suite Experience (Power BI or Fabric)
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.
Other SQL platform knowledge (Oracle, MySQL, PostgreSQL, etc.)
Bachelor’s degree in business or I.T. related discipline accepted or equivalent experience.
Tech Stack
Azure
ETL
MS SQL Server
MySQL
Oracle
Postgres
SQL
SSIS
Benefits
WFH Flexible
Apply Now
Home
Jobs
Saved
Resumes