Must have with ETL, data manipulation and data cleansing, very large datasets. Azure experience is a musthave. SQL Server databases (don’t send Oracle/PL-SQL candidates), Elasticsearch, and Spark are also required.
Data Engineer is responsible gathering and interpretingbusiness requirements from stakeholders, developing technical designs withvarious technologies and platforms. The Developer will assistwith design, documentation, end to end solutions. Expertise in datawarehousing, Python programming, data modeling and cloud technologies isrequired.
- Consult with stakeholders on software specifications and solutions
- Design and develop data integration / transformation solutions supporting both on premise and cloud-based data architectures.
- Perform code reviews, analyze execution plans, and re-factor inefficient code, understand index types and usage best practice, and have working knowledge of T-SQL performance tuning.
- Follow data standards, resolve data issues, develop appropriate unit testing use cases, understand and perform full regression testing, and complete system documentation for ETL processes.
- Ability to excel in an integrated environment, working closely with various business segments, and user teams to accomplish objectives
- Communicate effectively across multiple LOB and with stakeholders to review business requirements and propose solutions
- In-depth knowledge of relational databases, OLAP query tools, data mining, data structure, and data manipulation techniques.
- Previous Experience with Healthcare / PHI
- Design and implement OLAP solutions with SSAS (multi-dimensional and/or tabular mode).
- Azure data experience
- Direct experience with large data warehouses.
- Hands-on experience with Python, Spark and Elastic Search
- SSIS 2008-2012 or higher programming experience.
- Data Warehousing development experience.