JOB DESCRIPTION

Mastech Digital is an IT Staffing and Digital Transformation Services company.

Data Engineer

Quick Apply
Location: Clearwater, FL
Job Code: 220702
Posted: Oct 16, 2020
Description:

Mastech Digital provides digital and mainstream technology staff as well as Digital Transformation Services for all American Corporations. We are currently seeking a Data Engineer for our client in the Moving & Storage Solutions domain. We value our professionals, providing comprehensive benefits and the opportunity for growth. This is a Contract position and the client is looking for someone to start immediately.

Duration: 6 Months Contract

Location: Clearwater, FL (Remote until Covid-19 Ends)

Role: Data Engineer

Primary Skills: ETL

Role Description: The Data Engineer must have at least 7 years of experience. As the Data Engineer, you must have experience as a SQL Server developer and in-depth proficiency in Microsoft Business Intelligence stack, OLTP, OLAP, ETL, Operational Data Store (ODS), Data Mart, Data Warehouse, performance tuning and database technologies. 

You must be able to recognize and respond to complex and non-routine issues, and plan and lead large scale, complex assignments. Additionally, you will be responsible for the evaluation of systems and assisting with determining future needs to create and drive improvements of technology, processes and standards.

Essential Duties and Responsibilities:

- Serve as technical lead for large, complex projects to provide new or improved ETL services.

- Expert in analyzing, designing, developing, installing, configuring and deploying MS SQL Server suite of products with Business Intelligence in SQL Server Integration Services.

- Expertise in writing T-SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.

- Skilled in error and event handling: precedence Constraints, Break Points, Check points and Logging.

- Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.

- Experience in importing/exporting data between different using SSIS/DTS utility.

- Experience in ETL processes involving migrations and in sync processes between two databases.

- Experience in creating configuration files to deploy the SSIS packages across all environments.

Job Qualifications: Essential Skills, Abilities and Example Behavior(s)

- Collaborate: Able to act as part of a larger team outside of the immediate department or group; Able to understand the importance of working with peers in other areas or management to reach "best practice" solutions for the organization; Able to inform and seek information to anticipate and consider the impact of decisions or actions on the overall organization

- Demonstrate Sound Judgment: Able to make appropriate decisions and has the vision to understand their impact; Able to use factual information to develop logical assumptions; Able to examine alternatives and consider resources, constraints and risks before committing to action

- Act with Integrity: Able to demonstrate uncompromising adherence to ethical principles; Able to demonstrate honesty in all actions; Able to admit and correct mistakes promptly; Able to assume full responsibility and accountability for own actions

- Deliver Quality Results: Able to deliver top quality service to all customers (internal and external); Able to ensure all details are covered and adhere to company policies; Able to strive to do things right the first time; Able to meet agreed-upon commitments or advises customer when deadlines are jeopardized; Able to define high standards for quality and evaluate products, services, and own performance against those standards

- Think Strategically: Able to see the "big picture" and be future-thinking; Able to anticipate future trends and consequences accurately; Able to take a broad perspective; Able to create a vision of organizational objectives; Able to make decisions based on long-term company goals

- Develop Self: Able to accurately assess own strengths and development needs; Able to strive to improve those areas identified as needing development; Able to seek opportunity for development through the job, special assignments, training, or external activities

- Solve Problems: Able to apply both rational and creative processes and approaches to identify root causes of problems and solutions

- Take Initiative: Able to exhibit tendencies to be self-starting and not wait for signals; Able to be proactive and demonstrate readiness and ability to initiate action; Able to take action beyond what is required and volunteers to take on new assignments; Able to complete assignments independently without constant supervision

- Listen: Able to actively listen and convey understanding of the comments and questions of others; Able to understand the situations, viewpoints and feelings of others before expressing own view

- Speak Competently: Able to speak clearly and concisely; Able to use appropriate vocabulary for the audience; Able to get point across unambiguously and check for understanding

- Present Skillfully: Able to prepare and deliver clear, effective, and professional presentations

- Adapt: Able to maintain effectiveness by changing personal behavior and work routines / habits in response to new circumstances and requirements

- Be Professional: Able to project a positive, professional image with both internal and external business contacts; Able to create a positive first impression; Able to gain respect and trust of others through personal image and demeanor

- Advanced Computer User: Able to use required software applications to produce correspondence, reports, presentations, electronic communication, and complex spreadsheets including formulas and macros and/or databases. Able to operate general office equipment including company telephone system

Job Qualifications: Education & Experience Requirements

- BS in Computer Science, Engineering or related field desired; or equivalent work experience.

- 7+ years of ETL engineer experience in an enterprise with increasing responsibilities.

- Microsoft Certifications such as MCSE is preferred

- Strong troubleshooting and problem-solving experience in a large enterprise environment

- Strong presentation, communication, and interpersonal skills.

- Reliable contributor both individually and as a member of the team

- Possess math skills sufficient to perform required duties

Education: Bachelor’s degree in Computer Science, Electrical/Electronic Engineering, Information Technology or another related field or Equivalent.

Experience: Minimum 7 years

Relocation: This position will not cover relocation expenses

Travel: No

Local Preferred: Yes

Recruiter Name: Kyle Bahr

Recruiter Phone: 813.559.1854/785.840.4457

Equal Employment Opportunity

#LI-KB1

#Mastech2

Quick Apply
 
Your Email Address
Select Resume
*Up to 4mb: .docx,.doc, .pdf, .txt, .rtf, .htm files only.