Data Engineer

Job DescriptionJob DescriptionDescription : POSITION / JOB TITLE : Data Engineer

DEPARTMENT : Engineering

Want to apply Read all the information about this position below, then hit the apply button.

• 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.
• On-site 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 specializing 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 align with our clients' needs. We understand that the journey to the solution can be just as important as the destination – for 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 / ELT) consultant, database administrator 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

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 using ETL / ELT processes

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 Power BI and Microsoft Fabric

Knowledge of Semantic models and Data Analysis Expressions (DAX)

Experience with Big Data technology (e.g. Spark, Parquet) a plus

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, ETL / ELT, Cloud Data Platforms

Desire for continuous learning and to pursue professional certifications

Proven ability to consult and mentor others

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

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.

Requirements :