Description
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 skillsSQL Server design and development experienceUnderstanding of data profiling techniquesUnderstanding of performance optimization, data warehousing, cube architectureUnderstanding of common data extraction techniques across a diverse set of sources including structured and non-structured dataExperience with data cleansing and conforming techniquesDevelop standards and best practices to ensure data standardization and consistency as requiredStrong experience with dimensional modeling, star schema and Kimball Data Warehouse methodologiesDesign and develop data warehousing solutions for clients across a variety of industries and business sizes utilizing Microsoft's SQL Server PlatformPerform the role of subject matter expert for Microsoft Business Intelligence technologies including SQL Server and Analysis ServicesKnowledge of Multidimensional Expression (MDX) and Data Analysis Expressions (DAX) languagesFamiliarity with managing dimensional attribute history through Slowly Changing Dimension (SCD) conceptsWorking knowledge of ETL change detection solutions such as change data capture (CDC)Experience with Big Data technology a plusUnderstanding of SQL Server FastTrack and / or Parallel Data WarehouseFamiliarity with storage technologies (e.g. SAN, NAS, etc.) a plusTranslate business requirements and technical designs into well-developed solutions that meet client business goalsAbility to explain the pros and cons of architectural decisionsEvaluate and recommend new technologies as requiredDesign and implement technology best practices, guidelines and repeatable processesProvide technical assistance and cross training to other team members and clientsParticipate in the business intelligence community to promote the use of the Microsoft BI platform and general data warehousing best practicesAssist in pre-sales, scoping and requirements gathering processAbility to work closely with other project team members such as sales analysts, project managers, and software engineersREQUIREMENTS :
3 years Data experienceA Bachelor’s Degree in computer science, with emphasis in mathematics, or a similar analytical degreeT-SQL, SQL Server, SSIS, SSRS, SSASDesire for continuous learning and to pursue professional certificationsProven ability to consult and mentor otherBENEFITS AND PERKS :
Competitive salary with annual reviewsPaid Time Off and Paid HolidaysInsurance options include Health, Vision, and Supplemental OptionsEmployer-paid Dental, Short-Term and Long-Term DisabilitySafe Harbor 401(k) with company matchProfessionally drafted basic WillDependent Care Flex AccountsEmployee Assistance Program (EAP)Food, snacks, drinksTuition reimbursementPERSONAL CHARACTERISTICS :
Excellent communication, presentation, and interpersonal skills, confident with customersDetail-oriented, well-organized, and excellent ability to multi-taskEnergetic, comfortable working in a fast-paced environmentHard-working and motivated, able to take initiative and meet deadlinesComfortable working in a team-based environmentA 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.