- Strong T-SQL skills
- SQL Server design and development experience
- Understanding of data profiling techniques
- Understanding of performance optimization, data warehousing, cube architecture
- Understanding of common data extraction techniques across a diverse set of sources including structured and non-structured data
- Experience with data cleansing and conforming techniques
- Develop standards and best practices to ensure data standardization and consistency as required
- Strong experience with dimensional modeling, star schema and Kimball Data Warehouse methodologies
- Design and develop data warehousing solutions for clients across a variety of industries and business sizes utilizing Microsoft's SQL Server Platform
- Perform the role of subject matter expert for Microsoft Business Intelligence technologies including SQL Server and Analysis Services
- Knowledge of Multidimensional Expression (MDX) and Data Analysis Expressions (DAX) languages
- Familiarity with managing dimensional attribute history through Slowly Changing Dimension (SCD) concepts
- Working knowledge of ETL change detection solutions such as change data capture (CDC)
- Experience with Big Data technology a plus
- Understanding of SQL Server FastTrack and/or Parallel Data Warehouse
- Familiarity with storage technologies (e.g. SAN, NAS, etc.) a plus
- Translate business requirements and technical designs into well-developed solutions that meet client business goals
- Ability to explain the pros and cons of architectural decisions
- Evaluate and recommend new technologies as required
- Design and implement technology best practices, guidelines and repeatable processes
- Provide technical assistance and cross training to other team members and clients
- Participate in the business intelligence community to promote the use of the Microsoft BI platform and general data warehousing best practices
- Assist in pre-sales, scoping and requirements gathering process
- Ability to work closely with other project team members such as sales analysts, project managers, and software engineers
- 3 years Data experience
- A Bachelor's Degree in engineering, computer science, physics, mathematics, or similar analytical degree
- T-SQL, SQL Server, SSIS, SSRS, SSAS
- Desire for continuous learning and to pursue professional certifications
- Proven ability to consult and mentor other
- Competitive salary with annual reviews
- Paid Time Off and Paid Holidays
- Insurance options include Health, Vision, and Supplemental Options
- Employer-paid Dental, Short-Term and Long-Term Disability
- Safe Harbor 401(k) with company match
- Professionally drafted basic Will
- Dependent Care Flex Accounts
- Employee Assistance Program (EAP)
- Food, snacks, drinks
- Tuition reimbursement
- Excellent communication, presentation, and interpersonal skills, confident with customers
- Detail oriented, well-organized and excellent ability to multi-task
- Energetic, comfortable working in a fast-paced environment
- Hard-working and motivated, able to take initiative and meet deadlines
- Comfortable working in a team-based environment
- A hands-on attitude in a friendly work environment.
-
Data Engineer
1 week ago
Stellar Innovations Larchwood, United StatesLarchwood is responsible for managing the entire digital infrastructure and all software solutions for companies within the Schwarz Group. This includes selecting, providing, operating, and continuously developing IT infrastructures, platforms, and business applications. In order ...
-
Data Engineer
4 weeks ago
BECU Sioux Falls, United StatesOur business is guided by our people helping people philosophy which includes our team members.Utilize programming languages like Java, Pyspark, Python and Open Source RDBMS and NoSQL databases, and Cloud-based data warehousing services such as Redshift and Snowflake.Proficiency ...
-
Junior Data Engineer
1 week ago
Remotely Sioux Falls, United StatesJunior Data Engineer (1 year experience, hybrid) · Be part of our future This job posting builds our talent pool for potential future openings. Well compare your skills and experience against both current and future needs. If theres a match, well contact you directly. No guarant ...
-
Data Scientist Engineer
5 days ago
Remotely Sioux Falls, United StatesData Scientist Engineer (1 year experience, onsite) · Be part of our future This job posting builds our talent pool for potential future openings. Well compare your skills and experience against both current and future needs. If theres a match, well contact you directly. No guar ...
-
Senior Enterprise Data Engineer
5 days ago
Avera Sioux Falls, United States Full time*Only applicants who currently work for Avera Health in IT DA Analytics are eligible to apply. · Join the team at Avera · Award Winning Health Care: Avera has been named among the nation's 15 Top Health Systems, Forbes list of America's Best-in-State Employers and Level 10 Most ...
-
Lead Enterprise Data Engineer
5 days ago
Avera Sioux Falls, United States Full time*Only applicants that currently work for Avera Health in IT DA Analytics · Join the team at Avera · Award Winning Health Care: Avera has been named among the nation's 15 Top Health Systems, Forbes list of America's Best-in-State Employers and Level 10 Most Wired Health Care Org ...
-
Senior Enterprise Data Engineer
1 week ago
Avera Sioux Falls, United States Full timeBilling Services Manager - Dept. Only · Req # :2404516Avera Health-Avera McKennan HospitalPatient Financial ServicesSioux Falls, SDFull TimeDay ShiftMonday-Friday, 8:00am-5:00pm; 80hrs/2wks *Only applicants who currently work for Avera Health in Patient Financial Services are e ...
-
Animal Care Technician
1 week ago
Actalent Sioux City, United States Full timeDescription: · Help veterinarians out with samples and animal procedures · Set up animal rooms (clean and disinfect rooms before and after studies) · Monitoring of routine and room cleaning during live phase of study · Collect protocol specific research data in accordance · Good ...
-
Diesel Technician/Mechanic II
2 days ago
Penske Truck Leasing Sioux Falls, United States Full timeWhat's the Job? · Ready to move your career forward? As a Technician at Penske, you'll do exactly that. Here, you'll perform preventative maintenance and repairs of all levels on the newest and best maintained fleet of vehicles in the industry. You will help our customers keep th ...
-
Diesel Technician/Mechanic II
3 days ago
Penske Truck Leasing Sioux Falls, United States Full timeWhat's the Job? · Ready to move your career forward? As a Technician at Penske, you'll do exactly that. Here, you'll perform preventative maintenance and repairs of all levels on the newest and best maintained fleet of vehicles in the industry. You will help our customers keep th ...
-
Diesel Technician/Mechanic III
3 days ago
Penske Truck Leasing Sioux Falls, United States Full timeAddress: 201 S. Petro Avenue, Sioux Falls, SD. · What's the Job? · Ready to accelerate your career while helping our customers move forward? As a Technician at Penske, you'll do exactly that. Here, you'll do preventative maintenance and minor repairs on the newest and best mainta ...
-
Apex Ventures Falls City, United StatesFor our Department of Project Planning and Construction , we are currently looking to fill the position of Master/Technician for Network Construction with a focus on Gas/Water Networks/District Heating (wImId) · What you will be working on with us: · You will be responsible fo ...
-
IT System Administrator
1 week ago
Nexus Dynamics Minnehaha, United StatesAbout the Company · Since its founding in 1979, our company has continuously grown to become one of the leading manufacturers of cleanroom clothing and a system supplier of cleanroom consumables in Europe. In addition to innovative - and in some cases award-winning - clothing sys ...
-
Production Planner
1 week ago
Skyline Solutions South Sioux City, United StatesCreating Fascinating Things: Your Responsibilities · - Planning and coordinating production orders while considering customer orders, material availability/stock, and production capacities · - Efficient order processing through active management of interfaces between production a ...
-
Project manager for construction projects
1 week ago
Cascade Ventures Sioux City, United StatesThe DB Projekt Stuttgart-Ulm GmbH, as part of Deutsche Bahn, is responsible for implementing the commissioning of the new Wendlingen-Ulm high-speed line in 2022 and the restructuring of the Stuttgart railway hub in 2025. Join us in shaping the first ever Digital Hub and setting n ...
-
Design Engineer
2 weeks ago
FIMCO Industries North Sioux City, United StatesEngineer Summary: · The Design Engineer is responsible for designing, developing, and improving new or existing products and directs the building and testing of prototypes to meet customer and internal requirements. · Engineer Essential Duties and Responsibilities: · Creates new ...
-
Environmental Engineer I-Sr
11 hours ago
POET Sioux Falls, United StatesABOUT POET · At POET, it is our mission to be good stewards of the Earth by converting renewable resources to energy and other valuable goods as effectively as humanly possible. For over thirty years our drive and passion to change the world has enabled us to become the largest p ...
-
Hydrogen Operations Manager
6 days ago
FTI South Dakota, United StatesThe Hydrogen Operations Manager will have specific expertise in Hydrogen production and serve as the Energy practice's subject matter expert. The ideal candidate will have experience on projects in Hydrogen and other Industrial Gas, Chemical Hydrogen Renewable Energy, Oil & Gas, ...
-
Broadcast & Streaming Technology Manager
1 week ago
Midcontinent Communications Sioux Falls, United StatesJOB PURPOSE: · Supervise, organize, and lead all functions and activities of the production team to ensure optimal technical performance of Midco Sports, Production, and Creative Services by providing technical services including designing, maintaining, installing, and troublesho ...
-
Operations Engineer
3 days ago
POET Sioux Falls, United StatesABOUT POET · At POET, it is our mission to be good stewards of the Earth by converting renewable resources to energy and other valuable goods as effectively as humanly possible. For over thirty years our drive and passion to change the world has enabled us to become the largest p ...
Data Engineer - Sioux Falls, United States - Omnitech INC
Description
POSITION/JOB TITLE: Data EngineerDEPARTMENT: Engineering
***REQUIREMENTS: Qualified candidates must be legally authorized to be employed in the United States on a full-time basis for any position. Omnitech will not provide sponsorship for employment visa status (e.g., H-1B or TN status) for this position.***
***Onsite position, NO remote. ****
Do you have a data-driven, engineering mind and a consulting-type personality?
Omnitech is an established, locally owned software engineering firm that specializes in helping businesses create and fulfill opportunities through custom technology solutions. We are a Microsoft Partner that values a community of mentors to cultivate skills and interests that are in line with our client's needs. We understand that the journey to the solution can be just as important as the destination - for both clients and our engineers.
As a Data Engineer at Omnitech, you would qualify for multiple labels including business intelligence consultant, data warehouse consultant, data acquisition (ETL) consultant, database administrator consultant, master data management consultant, data analyst, data architect, data scientist to name a few. We don't believe in narrowly defined labels and hierarchy. We believe in helping people solve problems.
DESIRED SKILLS: (The applicable candidate must possess a number of the following.)
If you excel in a team centric learning environment and you're passionate about technology, please apply.