Job Description :
ETL BI Architect
King of Prussia, PA or Mechanicsburg, PA
6 month contract
Phone, Skype or In Person
Skills: Must have SQL experience.
Other skills that will be highly desirable:
Oracle Data Integrator (ODI) for ETL. Secondly, would consider Informatica
Large environment experience: 5 terabyte DW
Ability move data around efficiently
Strong Data Arch knowledge: build data models, dimensional modeling, data profiling
Clinical industry experience preferred
Role Description:
The Business Intelligence Architect is responsible for the delivery of end to end business intelligence solutions that support and enhance the financial, clinical, and quality outcomes of the organization. The role requires a passion for data and technology, thorough understanding of ETL in a data warehouse environment, excellent communication skills, understanding of business processes, knowledge of best practices, and the ability to provide quality actionable business intelligence using industry standard tools in a rapidly growing organization.
Responsibilities:
Collaborate with stakeholders, including executive management, to gather the technical requirements for business intelligence solutions
Acquire a deep understanding of source systems, knowledge of business processes, and thorough business unit knowledge through the interaction with subject matter experts, developers, architects, business leaders, and other relevant stakeholders
Design, develop and maintain data models for reporting and analyzing data related to business, regulatory, contractual and ad hoc requirements
Become a subject matter expert on the organizations data, processes, and reporting solutions
Develop ETL code, including but not limited to Oracle Data Integrator (ODI) packages, SSIS Packages, PLSQL packages, and scripts that take advantage of incremental loading methodologies like change data capture (CDC)
Perform unit, integration, performance, and regression testing
Develop and manage project documentation deliverables
Work with peers, SMEs and other stakeholders to ensure that the final solution meets the highest quality standards
Complete special projects and other functions, as required
Provide insights, recommendations and strategies to enhance the operational delivery of BI solutions, and technical direction
Qualifications:
Candidate will have a strong background in business intelligence, data management technologies, and industry best practices. The ideal candidate for this opportunity will possess the following work experiences:
3 years’ experience architecting business intelligence reporting solutions.
5+ years of ETL experience.
5+ years of experience analyzing, structuring and reporting data across an enterprise.
5+ years of experience utilizing data integration tools like ODI, SSIS, or Informatica.
5+ years of experience working on an RDBMS like Oracle or SQL Server.
3+ years of experience working in a data warehouse environment.
Experience with data modeling tools such as Erwin, Oracle Data Modeler or PowerDesigner.
Big Data experience is a plus (structured or unstructured)
Technical:
Proficient in SQL and PLSQL
Proficient in data warehousing concepts including dimensional modeling
Proficient in ETL design concepts including Change Data Capture (CDC) and Slowly Changing Dimensions( SCD)
Strong knowledge of an enterprise business intelligence platform like MicroStrategy, Tableau or Business Objects
Strong knowledge of an enterprise ETL platform like Oracle Data Integrator, SSIS, or Informatica
Non-Technical:
Must have a strong passion for data analytics
Strong analytical skills required; must be able to think critically through problems/requests
Must have the ability to effectively and efficiently collaborate with others
Must be detail oriented with a strong attention to detail and sensitivity to timelines
Must have excellent written and verbal skills since interaction with business will be common
Must be self-motivated, results-driven, and willing to learn and adapt in a fast-paced environment
Healthcare industry knowledge is preferable
Thanks and Regards,
Shivangi Singh | Team Lead | KPG99, INC
Certified Minority Business Enterprise (MBE)
Direct| |