Role Title: SQL Data Engineer
Location: 100% Remote but candidates should be located in the MD, VA, DC, or West Virginia area for occasional onsite meetings monthly/quarterly.
Role Type: 6-month Contract to Hire role.
W2 only on this assignment / C2C not available
PURPOSE:
Develops and executes ETL code and ensures that the data loading processes are reliable, and data quality remains high. Develop reports, dashboards, and tools for business-users. Develop technical solutions to improve access to data and data usage. Aggregate and analyze various data sets to provide actionable insight.
Qualifications
Experience:
Must have 3+ years hands-on experience with database management system
Must have strong experience with SQL
Must have some experience with ETL tools such as Informatica, Abinito, etc.
Knowledge and understanding of data exchange formats.
Knowledge and understanding of database design and implementation concepts.
Ability to recognize, analyze, and solve a variety of problems.
Knowledge and understanding of data movement concepts
Excellent communication skills both written and verbal.
Nice to Have
Experience with Business intelligence tools
Experience in the Healthcare industry
Education Level: Bachelor's Degree
Education Details: Information Technology or Computer Science or Engineering
In Lieu of Education: In lieu of a Bachelor's degree, an additional 4 years of relevant work experience is required in addition to the required work experience.
ESSENTIAL FUNCTIONS:
30% Writes and executes ETL code, primarily complex SQL script, but with a strong ability to leverage other technologies.
15% Analyzes and validates existing routines and communicates impacts. Assists with data transformation, manipulation, and presentation to users.
15% Works with Business Analysts, Business Intelligence Developers, Infrastructure Architects, and key business users to review, design, and develop data models and ETL processes.
10% Supports the Software Engineering team with data analysis and validation with extensive SQL queries.
10% Designs, configures, implements, monitors, and manages all aspects of Data Integration Framework.
10% Provides detailed guidance and performs work related to Modeling Data Warehouse solutions in the cloud OR on-premise. Understands Dimensional Modeling, Denormalized Data Structures, OLAP, and Data Warehousing concepts.
10% Defines Data Integration best practices for the data management environment.
#M2
System One, and its subsidiaries including Joulé, ALTA IT Services, TeamPeople, and Mountain Ltd., are leaders in delivering outsourced services and workforce solutions across North America. We help clients get work done more efficiently and economically, without compromising quality. System One not only serves as a valued partner for our clients, but we offer eligible employees health and welfare benefits coverage options including medical, dental, vision, spending accounts, life insurance, voluntary plans, as well as participation in a 401(k) plan.
System One is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity, age, national origin, disability, family care or medical leave status, genetic information, veteran status, marital status, or any other characteristic protected by applicable federal, state, or local law.