Data Engineer

The Business Intelligence Developer (Data Engineer) will work closely with business units and technical teams to understand, develop, improve, and maintain BI systems. The Business Intelligence Developer-DE will use their skills and expertise to transform data into metrics, automated reports, and dashboards providing actionable insights to improve decision-making at all levels of the business. The Business Intelligence Developer-DE will have strong data management skills and communicate directly with internal clients.

ESSENTIAL JOB DUTIES/RESPONSIBILITIES:

• Develops a deep familiarity with a variety of data sources including transactional databases, data warehouses, internal tools, and external integrations.
• Develops data programs that extract, transform, and load (ETL) data from the data warehouse, assures that architecture and development follow data warehouse best practices. This individual works with DW architects, data architects, hardware/software engineers, DBAs, application vendors, and managed services to ensure enterprise DW solutions are reliable, scalable, flexible, and low maintenance.
• Develops reports, dashboards, and tools using SQL, Python, SSRS, and QlikView, as well as other tools.
• Takes ownership of our data and constantly improves its quality and integrity; proactively identifying issues at every step and coordinating the implementation of required fixes.
• Partners with business stakeholders to understand their requirements and assist in the development of dashboards, visualizations, and solutions tailored to their needs.
• Documents existing processes, architectures, and code.
• Assists, mentors, and instructs lower-level developers and analysts as needed.
• Performs other duties as assigned and modified at the manager’s discretion.

EDUCATION AND EXPERIENCE CRITERIA:

• BA/BS degree in Computer Science, MIS, Business Administration, or related field required OR additional experience above the minimum may be considered in lieu of the required education on a year-for-year basis.
• Master’s level education with a combination of technical and business background is a plus.
• A minimum of 1 year of ETL and/or SQL development experience required.
• A minimum of 1 year of RDBMS experience (MySQL, SQL Server, PostgreSQL, etc.) strongly preferred.
• A minimum of 1 year of healthcare industry experience (or equivalent educational background) preferred.
• Experience programming with a high-level scripting language (Python, Perl, C#, etc.).
• Experience working with a variety of reporting and analytic tools (QlikView and SSRS strongly preferred).
• Proven experience working with business units; gathering their needs and creating solutions.
• Experience in query tuning and database engine optimization desired.
• Experience in database programming, stored procedures, data imports, and exports desired.
• Familiar with Medicare Advantage industry desired.