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.****** On-site position, NO remote. ****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.
