Data Engineer

1 day ago


Sioux Falls, United States Omnitech, Inc. Full time
Job DescriptionJob DescriptionDescription:

POSITION/JOB TITLE: Data Engineer

DEPARTMENT: 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.)

  • 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

REQUIREMENTS:

  • 3 years Data experience
  • A Bachelor’s Degree in computer science, with emphasis in mathematics, or a 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

BENEFITS AND PERKS:

  • 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


PERSONAL CHARACTERISTICS:

  • 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.

If you excel in a team centric learning environment and you’re passionate about technology, please apply.


**Omnitech participates in E-Verify and will provide the federal government with Form I-9 information to confirm work authorization.


**Omnitech is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, disability status, protected veteran status, or any other characteristic protected by law.

Requirements:



  • Data Engineer

    20 hours ago


    Sioux Falls, United States Omnitech, Inc. Full time

    Job DescriptionJob DescriptionDescription: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...


  • Falls Church, United States Amazon Data Services, Inc. Full time

    Data Center Engineering Operations Technician , DCC Communities at Amazon Data Services, Inc. summary: As a Data Center Engineering Operations Technician, you will maintain and operate critical infrastructure systems in some of the world's most advanced data centers. Your responsibilities include monitoring electrical, mechanical, and safety equipment,...


  • Sioux Falls, South Dakota, United States Omnitech, Inc. Full time

    Job OverviewOmnitech, Inc. is an established software engineering firm specializing in custom technology solutions for businesses.About the RoleWe are seeking a highly skilled Data Solutions Architect to join our team of experts in data-driven engineering and consulting. As a key member of our team, you will design and develop data warehousing solutions for...


  • Sioux Falls, United States Amesbury Group Full time

    AmesburyTruth is looking for a Data Coordinator to join our team in Sioux Falls! This role will be responsible for the creation and maintenance of Enterprise Resource Planning (ERP) system data in SAP S/4 HANA to support manufacturing components/assemblies in various lines at multiple production sites. Responsibilities Collaborate with other functional...


  • Idaho Falls, Idaho, United States Idaho National Laboratory Full time

    About the RoleWe are seeking a highly motivated individual to join our team as a Mobility Data Engineer Trainee. In this role, you will work with real-world transportation-related data and have opportunities to engineer data and create data pipeline software with significant impacts.This is an excellent opportunity for someone who wants to gain hands-on...


  • Falls Church, United States STEM IT Full time

    R&D division of a prominent DARPA partner, is hiring a Data Engineer for its Mclean based operations. This person will join an exclusive 12 person group of software engineers, data scientists and analysts who are collaborating to maximize large amounts of worldwide data. This position will feature: data ingestion, data wrangling, building cutting edge web...


  • Falls Church, Virginia, United States Redhorse Corporation Full time

    About Redhorse CorporationWe specialize in developing and implementing creative strategies and solutions with private, state, and federal customers. Our areas of expertise include cultural and environmental resources services, climate and energy change, information technology, and intelligence services.We are seeking a skilled Mid-Level Data Engineer to join...


  • Falls Church, United States Northrop Grumman Full time

    Requisition ID: R10181083 Category: Engineering Location: Falls Church, Virginia, United States of America Clearance Type: None Telecommute: Yes- May Consider Full Time Teleworking for this position Shift: 1st Shift (United States of America) Travel Required: Yes, 10% of the Time Positions Available: 1 At Northrop Grumman, our employees have...


  • Sioux Falls, South Dakota, United States Team TSP Full time

    Job OverviewTSP is a multidisciplinary design firm that delivers comprehensive facility design solutions by integrating architecture, engineering, interior design, and planning. Our expertise spans multiple sectors including healthcare and education.Key Responsibilities:Evaluate statistical data, client proposals, specifications, and manuals to determine...


  • Falls Church, United States By Light Professional IT Services Full time

    Company Overview By Light Professional IT Services LLC readies warfighters and federal agencies with technology and systems engineered to connect, protect, and prepare individuals and teams for whatever comes next. Headquartered in McLean, VA, By Light supports defense, civilian, and commercial IT customers worldwide. Position Overview By Light has an...


  • Falls Church, United States Northrop Grumman Full time

    Requisition ID: R10181083 * Category: Engineering * Location: Falls Church, Virginia, United States of America * Clearance Type: None * Telecommute: Yes- May Consider Full Time Teleworking for this position * Shift: 1st Shift (United States of America) * Travel Required: Yes, 10% of the Time * Positions Available: 1At Northrop Grumman, our employees have...


  • Falls Church, United States NasTech Global, Inc. Full time

    Role: Data Engineer Location: 3 days per week in Falls Church, Alexandria or Arlington (any location is fine but must be 3 days onsite)Duration: 1+ year ContractCitizenship: Active Top Secret Clearance Top Skills: Bachelors’ Degree and 7 years of experience or Masters Degree and 5 years, AWS Azure or MilCloud, ETL Position Requirements:• Experience with...

  • Data Engineer

    2 days ago


    Falls Church, United States SDV International Full time

    REQUIRED EXPERIENCE5-7 years professional experience with Big Data systems that include Apache Spark and Databricks5-7 years' experience with ELT processes, AWS, Microsoft Azure or MilCloud 2.0Direct work applying DoD Security Technical Implementation Guides (STIGs) and process automationSignificant experience with multiple coding languagesExperience...


  • Falls Church, United States SDV International Full time

    REQUIRED EXPERIENCE7-10 years professional experience with Big Data systems that include Apache Spark and Databricks7-10 years' experience with ELT processes, AWS, Microsoft Azure or MilCloud 2.0Direct work applying DoD Security Technical Implementation Guides (STIGs) and process automationSignificant experience with multiple coding languagesExperience...


  • Falls Church, United States Redhorse Corporation Full time

    About the Organization Now is a great time to join Redhorse Corporation. Redhorse specializes in developing and implementing creative strategies and solutions with private, state, and federal customers in the areas of cultural and environmental resources services, climate and energy change, information technology, and intelligence services. We are hiring...


  • Sioux Falls, United States Advanced Engineering & Environmental Services, Inc. Full time

    Position Description Advanced Engineering and Environmental Services (AE2S) is an award-winning, specialized civil/environmental consulting engineering firm that provides professional services and a unique brand of extreme client service. Our work environment is consistently recognized both locally and nationally for our great culture and values, proven...


  • Sioux Falls, United States Team TSP Full time

    Job DescriptionJob DescriptionTSP is a fast-paced, full-service design firm that successfully integrates architecture, engineering, interior design, and planning. Since 1930, TSP has been discovering facility design solutions that truly match the vision and mission of our clients.Primary Responsibilities: Team members will contribute to creating impactful,...


  • Sioux Falls, United States Design Tanks, LLC Full time

    Job DescriptionJob DescriptionJOB DESCRIPTIONMechanical/Manufacturing EngineerEssential Duties & ResponsibilitiesDesign, develop, and optimize manufacturing processes to improve efficiency and quality.Analyze production data and identify areas for improvement.Train and support production staff on processes and equipment.Lead and support Lean and Continuous...


  • Sioux Falls, United States HeartLand Express Full time

    , "title" : "CDL - A Truck Driver Jobs - OTR Solo Engineered - Chicago, IL to Sioux Falls, SD in Sioux Falls, SD", "description" : " For CDL-A OTR SOLO ENGINEERED truck drivers, it's all keeping the wheels turning. Heartland Express keeps you rolling by putting you in the newest, most comfortable truck you can drive. We know you drive for a living, and we...


  • Falls Church, United States Redhorse Corporation Full time

    About the Organization Now is a great time to join Redhorse Corporation. Redhorse specializes in developing and implementing creative strategies and solutions with private, state, and federal customers in the areas of cultural and environmental resources services, climate and energy change, information technology, and intelligence services. We are hiring...