Previous Job
Previous
ETL Developer
Ref No.: 18-05582
Location: Milwaukee, Wisconsin
Job Description:
  • Responsible for leading, developing, coding, planning, implementing and supporting BI user interface objects. Designs and Develops complex dashboards leveraging advance analysis and calculations for data visualization purposes. Builds complicated data models and integrates data using data integration/ETL platforms. Assist in design and implementation of data platform architecture and overall BI environment. Provides technical expertise in areas of data warehouse design, modern data visualizations, data analysis, data integration and analytical solutions to build clinical analytics platform. Solves complex technical problems. Develops standards, policies and procedures for the form structure and attributes of the business intelligence tools and systems.

Special Skills:
  • Working knowledge in one or more of the following: quantitative analysis, information systems, project management and agile rapid development methodology. Advance knowledge of development, delivery, release and maintenance of BI and analytics applications. Proficient in user interface design and engaging user experience design for applications. Advanced knowledge of data warehouse and data mart design, dimensional data modeling and challenges. Detail oriented with the ability to synthesize information from multiple sources. Demonstrates excellent follow-up skills and the ability to take initiative as well as a proactive problem solving approach. Excellent verbal and written communication skills. Ability to listen and convey messages in a clear, concise, and empathetic manner using the appropriate communication medium. Team oriented with good interpersonal skills and the ability to collaborate effectively with peers and customers. Comfortable providing input and alternate views in a healthy, constructive way.

Job Standards:
  • Design and develop interactive and complex analytical dashboards and reports with modern data visualization concepts and design on analytics platform. Expert use of advanced analysis, complex expressions and multi-dimensional objects
  • Develop effective data models via scripting, perform analysis for data profiling and provide technical expertise in ensuring data integration and reconciliation across multiple source systems
  • Play a key role in design and implementation of data warehouse architecture by building scalable data model using dimensional modeling (Kimball Methodology) concepts. Leverage emerging data warehousing trends and incorporate such concepts in architecture and design.
  • Perform data migration and data integration tasks like Extract, Transform and Load (ETL) using ETL platform or data modeling and scripting limiting manual intervention whenever possible
  • Perform data migration and data integration tasks like Extract, Transform and Load (ETL) using ETL platform or data modeling and scripting limiting manual intervention whenever possible
  • Develop SQL scripts for data acquisition and manipulations in SQL-compliant or other data sources.
  • Ensure quality control of design and implementation of dashboards, reports and overall BI platform. Test and debug ETL tasks and perform data quality check for data reconciliation
  • Integrate extensions and other 3rd party plugins to enhance data visualization capabilities
  • Advice on performance optimization, database performance, tune data loads and applications for efficient performance
  • Follow implementation standards and deployment process within Agile/Scrum methodology for rapid development
  • Perform complex data analysis to identify and communicate trends in risks and opportunities
  • Participate in design, creation and maintenance of complex dashboard and data structures to keep consistent with business requirements and processes.
  • Promptly respond to ad-hoc reporting and data requests from strategic and operational leadership.
  • Partner with other analytics and data teams to discuss data requirements and develop data transfer solutions.
  • Participate in project teams as necessary and assist with timely delivery and project timelines.
  • Support and maintain clinical analytics platform. Proactively validate and test data structures, dashboards, reports and other programming codes as needed.
  • Performs other duties as assigned.

Warm Regards,
Abhishek Srivastava
abhishek.s@lancesoft.com
703-889-6668