Compensation: $84,690.00 - $125,110.00 /year *
Employment Type: Full-Time
Industry: Information Technology
Loading some great jobs for you...
Full time position Data Engineer
Location: Cincinnati, OH*This position does not offer sponsorship
Join the PatientPoint Business Intelligence & Data Science team in our new Kenwood Cincinnati headquarters office space. Work for a growing entrepreneurial organization where you can apply your critical thinking skills and your ideas and suggestions are valued. Be a part of a team that implements emerging technology and applies the latest quantitative methods to solve complex problems.
What you will be doing
Far beyond creating views and using outer table joins, this position creates fully automated data flows that ingest data from new and external APIs and transforms the data into usable formats for downstream dashboards, predictive models and machine learning.
Build data ingestion & transformation processes to support industry leading data science applications in predictive modeling and machine learning deployments. Design, create and deploy solutions that aggregate and transform - enabling the use of billions of log records from digital touchscreen devices.
This position offers you a great opportunity to build out an entire ETL architecture from the ground up, flexibility and the responsibility to develop a stable and reliable data platform. This person plays an important role in selecting technology, vendors and team role development.
As a developer, you will prototype new ideas, run experiments, and iterate to better design data driven solutions to business problems. On other projects you might create queries and scripts for deployment of features in the production database and enterprise data warehouse, including obtaining data from multiple external APIs.
Design and develop automated processes to perform scheduled tasks, ETL, data validation and maintenance activities; enabling quantitative analysts to tackle problems in sales force planning, touchscreen user interaction, predictive maintenance, operations and many other subject areas.
Plus, there will be minimal travel, we have a new office space, you will have career growth opportunities, you will get interesting projects and can enjoy free coffee!
What you need to be successful
A college degree and several years of work experience. Your experience should include direct hands-on work with Microsoft SQL Server Integration Services (SSIS 2012 and higher).
Mastery of SQL programming and relational data extract, transformation and loading (ETL), including data definition, transformation and preaggregation techniques required.
Experience with obtaining data from external APIs, JSON and XML required. You will be asked to provide several examples during the interview process.
Mastery of MS SQL Server 2012 and higher required, other RDMS such as Oracle or MariaDB helpful.
Knowledge and demonstrated ability with database administration and performance tuning.
Working knowledge and experience with a general-purpose programming language such as Python.
Experience with storage and retrieval of data in NoSQL databases helpful.
Knowledge of other ETL tools such as Dell Boomi or Informatica helpful.
Visa sponsorship is not available for this position.
Kudos if you have:
Working knowledge of the R programming language.
Experience with geospatial analysis.
Experience with reporting using SalesForce Wave Analytics
Working knowledge of graph databases.
This is an excellent opportunity and includes a competitive pay and benefits package, including health, dental, vision, disability, and life insurance as well as 401(k) retirement plan with matching company contribution, paid time off, and holidays. No relocation is available.
PatientPoint is a patient engagement solutions company passionately committed to making every doctor-patient engagement better. By harnessing the power of technology, our omnichannel platform more effectively educates and empowers patients, caregivers and staff to deliver improved health outcomes and an enhanced patient experience. For 30 years, hospitals, health systems, physician offices and sponsoring brands have trusted PatientPoint and its more than 450 team members to provide a uniquely integrated experience across care settings. Learn more at patientpoint.com.
Employer is EOE/M/F/D/V
Associated topics: data analytic, data center, data engineer, data integrity, data manager, data quality, data warehouse, database administrator, mongo database, teradata
* The salary listed in the header is an estimate based on salary data for similar jobs in the same area. Salary or compensation data found in the job description is accurate.
Loading some great jobs for you...