This position plays an important role in extracting, transforming, and loading data into our data infrastructure and presenting meaningful insights using data visualization tools. The ideal candidate is proficient in Python, R, and SQL, and also with various ETL and analysis tools and software.
The responsibilities and duties include:
- Design and develop BI solutions using report and visualization software such as Tableau, Power BI, and IBM Cognos
- Accountability: owning the delivery of visualizations and serving as a technical lead
- Code, test, debug, implement, and document ETL pipeline
- Develop and maintain ETL pipelines for multiple data sources
- Troubleshoot and recommend solutions for optimized design techniques to build dashboards and reports
- Expert knowledge in SQL skills including stored procedure, trigger, index etc.
- Experience with change management with respect to people, processes, and technologies
- Develop, maintain, and support business applications (SQL/web-based apps)
- Identify data solutions through close collaboration with department managers
- Streamline and improve internal processes and reporting
- Drive efficiency and operational improvement using data modeling techniques
- Support and train users by providing directions, corrections, and enhancements; communicate with users to find solution to case
- Analyze user requirements, procedures, and problems to provide coaching on system use, recommend changes and automation to improve efficiency
You’ll need the following qualifications and experience:
- Bachelor’s degree in an appropriate field of study like Computer Science, Data Science, or Information Technology
- Minimum four years of ETL, visualization, and computer programming experience (Python, R, SQL)
- Previous relevant experience in building visualizations to solve business problems with Power BI and Tableau
- Experience with development and maintenance of ETL pipelines using different methods (SSIS, PySpark, Azure Data Factory, Streamsets, Databricks)
It’s a strong plus if you have:
- Experience with Healthcare/Mental Health environment
- Collaborate with team leads to identify gaps and constraints associated with business requirements and processes and aid in providing solutions to resolve the process issues
- Strong communication and interpersonal skills
- Strong organization and time management skills
- Ability to effectively handle multiple priorities
- Ability to operate across the business and in different environments and cultures