Job Description
DW/ETL Developer Position Summary:
RedBrick Health is actively seeking a highly skilled and motivated Data Warehouse and ETL Developer to design, and develop ETL and reporting solutions. RedBrick's application portfolio includes consumer websites; operations management applications; and internal software systems as well as numerous diverse internal and external data providers and consumers. Our data management systems include an operational data store; a data warehouse; healthcare analytics; and a Pentaho reporting system.
- RedBrick Health is looking for a DW/ETL developer / analyst who can translate business requirements into creative and practical solutions. Focus, enthusiasm and a dedication to excellence are all personal characteristics highly valued in the RedBrick Health organization.
- This is an opportunity to help build and expand the systems that will drive the growth of a company aiming to shape the future of health care. Join a growing company with a virtuous purpose: Help People Be Healthy.
Essential Job Functions:
- Utilize ETL/ DW tools to build data integration, analysis, and reporting solutions for our clients and internal users
- Analyze and understand data sources and end-user requirements to deliver ETL solutions for managing RedBrick data
- Design and implement information and report applications that meet defined requirement details
- Author new reports and modify existing reports using Pentaho reporting software to meet business specifications
- Develop and maintain technical specifications, high-level designs and end user documentation of assigned projects and analysis
- Support solutions through the entire development lifecycle including system testing, bug fixes, performance tuning and production support
- Work with information delivery and business owners to understand business needs and to analyze and clarify information related requirements
- Assist with the development of the data models for the data warehouse guided by the data warehouse architect
- Perform source system analysis and design mapping logic between source systems and the Operational Data Store and the Data Warehouse
- Analyze data in source systems to assess data quality and make recommendations for addressing within the source systems or as part of the ETL process
- Performance tuning of ETL and reporting applications
Essential Job Requirements:
Education: A bachelor's of science degree in Computer Science, Software Engineering, Electrical Engineering or Management Information Systems
Experience: Experience: 3+ years of ETL/Data Warehouse development
Required Skills:
- Delivering ETL solutions using an ETL tool to do mappings, transformations, and execution control for both operational data as well as warehouse/reporting data
- Experience with data warehouse development and support
- Operational and Analytical report development using dimensional and relational databases
- Experience as a contributor in all phases of project life cycle methodology for data warehouse, data management, and report application development
- Expertise in SQL and the ability to build SQL statements and scripts
- Demonstrated understanding of data quality principles and practices
- Competency in analyzing business requests and translating them into report and analytics requirements
- Excellent communication and interpersonal skills
Preferred Skills:
- Experience with the Pentaho Data Integration and BI tool sets
- Experience with MySQL database
- Accustomed to a fast-paced or startup environment
- Experience in the healthcare or health insurance building ETL, reporting, and analytics capabilities specific to those sectors Physical Requirements:
- Working in an office environment requiring sitting for long periods and extensive use of a computer
Location
Minneapolis
How to apply
Send resumes to ssheehy@redbrickhealth.com