The Data Engineer is responsible for delivering data warehouse and analytic solutions by ingesting, integrating, and curating data, and building analytical solutions.
Serves as a functional and content expert of the data warehouse to synthesize raw data into actionable information.
Applies knowledge of relational databases including advanced SQL knowledge and the ability to create complex queries and stored procedures.
Collaborates with the Data Engineering team in the design and execution of solutions.
Ensures that new and existing data models and databases are consistent with approved data architecture standards.
Provide facilitation, analysis, design, and execution of architecture solutions and ensure solutions are leveraged. Create, document, and communicate the integration approach of all the components of the solution.
Maintain knowledge of current trends and development in the field. Actively explores emerging technologies.
Assists with ETL/ELT design and development including data analysis, source-target mapping, quality profiling, change data capture, code performance.
Document all programming changes and design, system modifications and their associated maintenance.
Own analytics projects and be accountable for collaborating with the business to gather requirements, execute to provide analytical solutions, which exceed customer expectations.
Work collaboratively with and support multi-departments efforts and projects.
Mentor staff by sharing skills, experience, knowledge, and expertise on analytic tools and solutions.
Provide training and support through the organization on the use of analytics tools.
Performs other duties and functions as assigned.
Qualifications
Required:
Bachelor’s degree or equivalent experience in relevant field
5+ years of experience in the IT industry
3+ years of experience with SQL Server 2016 or above
3+ years of experience with data warehousing architecture concepts and BI tools
3+ years of experience with designing and implementing ETLs
Preferred:
Previous experience with Cloud Technologies (Azure, Data Lake, Data Bricks, Spark)
Previous experience with scripting language such as Python
Previous experience with ANSI X12 EDI transactions (834 Eligibility and 837 Claims)
Experience with Master Data Management concepts and implementation
Experience with Microsoft Power BI
Previous healthcare experience
Knowledge of work prioritization using Agile framework