Elevate Patient Financial Solutions has an exciting career opportunity available as a Data Engineer III. This position will be remote. The Full Time schedule for this role will be Monday-Friday: 8:00am-5:00pm with some flexibility.
Job Summary
The purpose of this position is to perform Data Development functions which include: the architect and design of new or enhancement of existing enterprise database systems; maintenance and/or development of critical data processes; unit and system testing; support and help desk tasks; expert support of the data solutions. It also requires defining and adopting best practices for each of the data design and development functions as well as visualization and ETL processes. This position is also responsible for architecting ETL functions between a multitude of critical relational databases and external data files.
Essential Duties and Responsibilities
- Work with a highly dynamic team focused on Digital Transformation.
- Understand the domain and business processes to implement successful data pipelines.
- Provide work status, and coordinate with Data Engineers, and Data Architects.
- Manage customer deliverables and regularly report the status via Weekly/Monthly reviews.
- At an expert level: Design, develop and maintain ETL processes as well as Stored Procedures, Functions and Views
- At an expert level: Program in T-SQL with relational databases including currently supported versions of Microsoft SQL Server.
- At an expert level: Write high performance SQL queries using Joins, Cross Apply, Aggregate Queries, Merge, Pivot.
- Design normalized database tables with proper indexing and constraints.
- Perform SQL query tuning and performance optimization on complex and inefficient queries.
- Provide expert guidance in the use of table variable, temporary table, CTE appropriately to deal with large datasets.
- Collaborate with DBA on database design and performance enhancements.
- Leading in all phases of the software development life cycle in a team environment.
- At an expert level: Debug existing code and troubleshoot for issues.
- Design and provide a framework for maintaining existing data warehouse for reporting and data analytics.
- Create and establish best practices, design, develop, test and document ETL processes.
- Design and Develop data cleansing routines utilizing complex data quality functions involving standardization, transformation, rationalization, linking and matching.
- Keep up to date with the latest database features, data techniques, and technologies.
- Support current business applications including the implementation of bug fixes as needed.
- Mentoring of other Data Engineers.
- Effectively communicate progress through the project execution phase
- Other duties as assigned.
Qualifications and Requirements
- To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or abilities.
- Minimum 8 years of work-related experience in T-SQL, SSRS and ETL. If candidate has relevant education in computer science, computer information systems, or related field, lack of experience can be supplemented by education as follows:
- Microsoft Certifications – 1 year
- Associate degree – 1 year
- Bachelor’s Degree – 2 years
- Master’s Degree – 3 years
- Minimum 4 years of experience with development and maintenance of Data Factory data pipelines.
- Minimum 4 years of experience with development and maintenance of data pipelines using the DataBricks component in Azure.
- Minimum of 4 years of experience using DevOps CI/CD in Azure.
- Understanding of data lakehouse architecture in Azure.
- At an expert level: Experience in developing, maintaining, and supporting database processes using Microsoft SQL Server with emphasis on .NET technologies.
- Proficient with the following: T-SQL, SSRS, SSIS, SSAS, Data warehousing, ETL, Python.
- Demonstrated ability to perform above listed essential job functions.
- Ability to work in a dynamic environment with changing requirements.
- Good communication and presentation skills
- At an expert level: Working experience with a wide range of data technologies, data modeling, and metadata management.
- At an expert level: Working experience using SQL.
- Able to multi-task and adapt to shifting priorities.
- Able to meet deadlines set in project planning.
- Remote and Hybrid positions require internet connections that meet the
- Company’s upload and download speed criteria.
Benefits
ElevatePFS believes in making a positive impact not only within our industry but also with our employees –the organization’s greatest asset! We take pride in offering comprehensive benefits in a vast array of plans that contribute to the present and future well-being of our employees and their families.
- Medical, Dental & Vision Insurance
- 401K (100% match for the first 3% & 50% match for the next 2%)
- 15 days of PTO
- 7 paid Holidays
- 2 Floating holidays
- 1 Elevate Day (floating holiday)
- Pet Insurance
- Employee referral bonus program
- Teamwork: We believe in teamwork and having fun together
- Career Growth: Gain great experience to promote to higher roles
The salary of the finalist selected for this role will be set based on a variety of factors, including but not limited to, internal equity, experience, education, location, specialty and training. This pay scale is not a promise of a particular wage.
The job description does not constitute an employment agreement between the employer and Employee and is subject to change by the employer as the needs of the employer and requirements of the job change.
ElevatePFS is an Equal Opportunity Employer
#IND123
