Position:  Business Intelligence & ETL Developer (Project position)
Location:  Cincinnati, OH
Job Id:  467
# of Openings:  1

 
 
 
Title: Business Intelligence & ETL Developer  (project position)
Location: Cincinnati, Ohio 
Department: Business Intelligence & Data Science
 
Project duration:  Approximately 12 weeks
 
 
Project Summary
High impact, high responsibility. Build ETL processes and a dashboard platform to support industry leading data science applications, predictive modeling and machine learning deployments.
Plan and deploy aggregations and transformations that enable the use of millions of log records from digital touchscreen devices.
This position offers you a great opportunity to build out an entire dashboard reporting platform from the ground up, flexibility and the opportunity to influence decisions across the business unit.
Design and implement data storage and tools to access millions of log records from digital touchscreen devices.
Entrepreneurial environment that values innovative thinking and using data to solve problems in a collaborative environment. Minimal travel.  Growth potential.
 
Key Responsibilities
Prototype ideas, test and iterate to better design data driven solutions to business problems.
Analyze, plan, and execute ETL development, monitoring and enhancements.
Prototype ideas, run experiments, and iterate to better design data driven solutions to business problems.
Create queries and scripts for deployment of features in the production database and data warehouse, including obtaining data from multiple external API's
Design and develop automated processes to perform scheduled tasks, ETL, data validation and maintenance activities.
Collaborate, Design and develop backup and recovery plan and processes.
Pro-actively analyze ETL and database performance, then make recommendations for improvements.
Knowledge or demonstrated ability to learn Microsoft Power BI, including DAX formulas as necessary.
Working knowledge and experience with a general-purpose programming language such as Python.
Experience with obtaining data from external API’s and flat files required.
Create queries and scripts for development and deployment of features and for production database and data warehouse support.
Design and develop automated processes to perform scheduled tasks, ETL and maintenance activities.
Communicate insights and recommend areas for further data platform enhancements.
 
Characteristics of successful candidates
Strong interpersonal, communication and consulting skills. Ability to establish, and maintain successful cross functional relationships and collaborate closely with multiple teams.
Collaboration experience with developers, program managers, and product managers in an open, creative environment.
Focused and results oriented: consistent ability to deliver and by deadline.
“Can do” attitude in an environment of entrepreneurship and opportunity, with changing priorities.
Critical thinker with the ability to identify, solve problems & thrive in a fast-paced environment.
 
 
Education, Training and Experience
Bachelor's required, Masters preferred. Information systems, Computer Science, business analytics, informatics, information technology, or a related field preferred.
Minimum 3 years, 5+ years preferred. Only direct and hands-on work-related experience with Microsoft SQL Server Integration Services (SSIS 2008 and higher) apply to this requirement.
Mastery of SQL programming and relational data ETL, including data definition.  
Mastery of MS SQL 2012 and higher required.
Mastery of MySQL v. 5.6 and higher required.
Knowledge of other RDMS such as Oracle or MariaDB helpful.
Experience with obtaining data from external API’s in JSON format required.
Experience with storage and retrieval of data in NoSQL databases helpful.
Experience with SalesForce Wave Analytics helpful
Knowledge of other ETL tools such as Dell Boomi or Informatica helpful.
Knowledge or demonstrated ability to learn Microsoft Power BI, including DAX formulas as necessary.
Working knowledge and experience with a general-purpose programming language such as Python.
Experience with storage and retrieval of data in NoSQL databases helpful.
Experience with graph databases helpful.
 
 
This is an excellent opportunity and includes competitive pay, growth potential and opportunity for other project work.    No relocation is available.  
PatientPoint® is the trusted innovator of patient and physician engagement solutions at the point of care. For 30 years, PatientPoint has delivered positive outcomes for patients, providers and sponsors with its award-winning health education and innovative technologies. From primary care to specialty practices, urgent care clinics to hospitals, PatientPoint offers a comprehensive communication platform that provides patient engagement solutions across care settings. Learn more at www.patientpoint.com
 
Employer is EOE/M/F/D/V.
 

Apply for this Position
Go back to the job list