RESPONSIBILITIES:
Kforce's client, a leading provider of health and wellness products is searching for a Senior Data Engineer to join their team! This position is direct hire, full time and is on-site 3 days a week in Fort Washington, PA. (No exceptions). This role serves as the primary technical resource for managing and moving data in and out of the Data Warehouse.
Job Purpose:
The Enterprise Data Warehouse (EDW) is the corporate repository of integrated operational data. The company is moving from on-premises management of its Data Warehouse and Business Intelligence to cloud Data Management and reporting. Working with EIS and offshore resources, this role will lead the development of the cloud DW while supporting the current DW environment.
External Contact:
This position will work with external data and system vendors to exploit cutting edge Data Management technologies and integrate/export data following company security guidelines.
Internal Contact:
This position will have significant contact with Offshore development resources, EIS physical IT resource management and Architecture staff.
Essential Job Responsibilities:
Working with IT and business resources, support the Data Warehouse strategy and Business Intelligence initiatives:
* Lead development activities to migrate the current on-premises SQL Server DW to Snowflake on AWS
* Gather requirements for Data Warehouse improvements and translate them to high level design documents including Physical Data Models
* Design and develop transformation processes and data structures for the Data Warehouse following best practice procedures
* Lead resolution of Data Warehouse load issues
* Support the analytical needs of the business users
* Partnering with business stakeholders and technical report developers, establish, maintain, and promote consistent methodology for reporting and analytics deployment; Perform ad hoc data analysis to meet business unit data validation needs
REQUIREMENTS:
* BS degree, preferably in Information Technology, Management Information Systems, Computer Science, or similar discipline
* Post-college training in Data Management and vendor tool use
* 5-8 years of Data Warehousing/BI experience
The candidate must:
* Be well versed in Data Warehouse design concepts including Kimball and Inmon methodologies
* Have hands-on experience with ETL and ELT methodologies and tools
* Have experience with SQL Server 2016 and SSIS
* Have experience with business reporting requirements analysis
* Have familiarity with Data Management and Business Intelligence tools, such as Business Objects, Microsoft Power BI, Qlik Sense, Tableau, Looker, AWS S3 and Redshift, or Snowflake
* Have demonstrated ability to clearly communicate with all levels within an organization
* Have experience leading small or offshore development teams
* Have understanding and experience with building and deploying Business Intelligence and analytics applications
* Familiarity with Financial, Sales, Marketing, and Logistics reporting environments
* Strong sense of leadership, strong analytical skills, excellent communication Have expert skills and good technical abilities
Preferred Skills:
* CBIP (Certified Business Intelligence Professional)
* CDMP (Certified Data Management Professional)
* Vendor-specific certifications
* SSAS
* Analytics design and development is preferred
* Hands on development experience with .NET and/or Java is a plus
* Comfortable working in a fast-paced team; Capable of grasping new concepts quickly and acting with a sense of urgency
The pay range is the lowest to highest compensation we reasonably in good faith believe we would pay at posting for this role. We may ultimately pay more or less than this range. Employee pay is based on factors like relevant education, qualifications, certifications, experience, skills, seniority, location, performance, union contract and business needs. This range may be modified in the future.
We offer comprehensive benefits including medical/dental/vision insurance, HSA, FSA, 401(k), and life, disability & ADD insurance to eligible employees. Salaried personnel receive paid time off. Hourly employees are not eligible for paid time off unless required by law. Hourly employees on a Service Contract Act project are eligible for paid sick leave.
Note: Pay is not considered compensation until it is earned, vested and determinable. The amount and availability of any compensation remains in Kforce's sole discretion unless and until paid and may be modified in its discretion consistent with the law.
This job is not eligible for bonuses, incentives or commissions.
Kforce is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status.