Data Engineer

Summary: Vital Services is seeking a talented and experienced Data Engineer to join our growing Information Technology team. This is an extraordinary opportunity to be a part of, and play an integral role in, the development of our Data & Reports team!

****This Role may be based at our Oak Ridge TN or Allen TX office, or open to remote*****

As a Data Engineer, you will work closely with our customer’s department leads and project coordinators to evaluate business needs and develop reports and dashboards to support strategic goals. You will also collaborate with other members of the Data and Information Technology teams to plan, design, develop, test, and deploy business intelligence data solutions. A successful candidate will understand and fulfil their responsibility to develop and support databases, data structures, and data flow, with a focus on data integrity and reliability.

Essential Duties and Responsibilities of the Data Engineer include the following:

• Design, develop, and maintain reports and dashboards using SQL Server Reporting Services, Microsoft Power BI, and other reporting and business intelligence tools.
• Work with various stakeholders to gather requirements, develop a deep understanding of data sets, and establish KPIs needed to fulfill business requests.
• Troubleshoot failures, performance, and data issues within existing reports.
• Understand ETL and data warehousing in order to pull necessary data for reporting purposes.
• Perform Ad Hoc reporting and/or analysis as needed to support the business goals through data-driven decision making.
• Perform dynamic data manipulation, in-depth data summarization, and apply sophisticated sorting and filtering techniques to improve data insights and reporting precision.
• Assist in supporting and maintaining data repositories.
• Assist with development of reports and BI tools.
• Design, create, modify, and support ETL processes.
• Perform unit testing, end-to-end testing, and validation of applications in development environments to ensure defect-free releases.
• Create performance database queries and database designs using T-SQL and Microsoft SQL Server.
• The ability to multi-task and work within a time tracking and ticketing system to track tasks and business requests.

Qualifications:

• A minimum of 4 years of experience in data engineering, analytics, or reporting roles.
• At least 2 years of work experience in Business Intelligence is preferred.
• Bachelor’s degree in Mathematics, Economics, Computer Science, or other quantitative degrees preferred.
• Strong knowledge of SQL, SSRS, MS Excel, Power BI, Oracle, Tableau, and other Business Intelligence tools.
• Knowledgeable and experienced with different data sources, such as, MS SQL, Excel files, Azure SQL, Azure Cosmos DB, AS400, DB2, and Cloud Data Sources.
• Deep understanding of SQL databases and query language.
• Advanced Excel skills.
• Familiarity with data storage, retrieval, and manipulation methods within both relational and non-relational database architectures.
• Knowledge and experience in the Insurance industry is a plus.

Competencies and Success Factors

Customer Service – Manages difficult or emotional customer situations; Responds promptly to customer needs; Solicits customer feedback to improve service and responds to service requests; Meets commitments.

Interpersonal Skills – Focuses on solving conflict, not blaming; Maintains confidentiality; Listens to others without interrupting; Keeps emotions under control; Remains open to others' ideas and tries new things.

Communications – Speaks clearly and persuasively; Listens and gets clarification; Responds well to questions; Demonstrates group presentation skills; Participates in meetings; Exhibits objectivity and openness to others' views; Gives and welcomes feedback; Writes clearly and informatively and can read and interpret written information.

Business Acumen – Understands business implications of decisions; Displays orientation to profitability; Demonstrates knowledge of market and competition; Aligns work with strategic goals; Follows policies and procedures; Completes administrative tasks correctly and on time; Supports organization's goals and values; Strives to continuously build knowledge and skills; Shares expertise with others.

Judgment – Makes timely decisions; Exhibits sound and accurate judgment with consideration for all stakeholders and can support decisions made; Asks for and offers help when needed.