Data Engineer

Omnitech is growing our data consulting services. In our market area, business and technology leaders recognize Omnitech as the leader in software engineering and consulting. As a Microsoft Gold Partner in Application Development, Omnitech continues to focus on deepening the talent pool in the community we serve. As for Data, Omnitech has a solid foundation to grow upon. The Omnitech team experiences include designing, warehousing, reporting, transforming, configuring, performance tuning, and operating both transactional and analysis data systems.

A Data Engineer at Omnitech would qualify for multiple of the following 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, or many other labels currently being used. At Omnitech, we don’t believe in labels and hierarchy. We believe in helping people solve problems. We are looking for an engineering caliber person that focuses on data and has a consulting type personality.

• A curious analytical mind with ability to understand business objectives, ask insightful questions, and be detailed in implementation
• A track record of helping companies get value from data management and business intelligence
• Diverse understanding of industry tools, software and techniques; especially Microsoft SQL Server platform and tools
• A desire to mentor and be mentored
• A history of working on multidisciplinary teams in a productive manner
• Professional image and demeanor with the ability to present oneself in a consultative, confident, and yet humble manner

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

• 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
• Desire for continuous learning and to pursue professional certifications
• Proven ability to consult and mentor others

• 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

• MSDN Premium and Azure licensing as Microsoft Gold Partner
• Opportunities for formal and informal training on new technologies
• Support for career and life goals and development
• Free soda, coffee and other ingestible fuel to keep you going
• On-site exercise room with equipment
• Company matching on the 401k plan
• Reimbursement for tuition and certification costs

Qualified candidates must be legally authorized to be employed in the United States on a full-time basis for any position. Omnitech will not sponsorship for employment visa status (e.g., H-1B or TN status) for this position.

If you are interested in being part of an exciting and growing company, please apply. If you have what it takes to support our organization, then send your resume and salary requirements via e-mail to