What are the responsibilities and job description for the ETL Data Warehouse Developer position at Y & L Consulting Inc.?
Job Details
<>Duties and Responsibilities
Essential Functions:
Performs advanced ETL/data warehouse architectural work including data warehouse design, data modeling, and metadata design
Works closely with business SMEs to reverse engineer the rules that govern business processes, corresponding data streams, and associated source systems
Translates business needs into high level technical designs for business intelligence solutions; applies rapid iterative development methodologies as appropriate to ensure the solution keeps pace with business needs
Perform in-depth, thorough, and accurate reporting or ad hoc analysis as needed
Contributes to the long-term vision of the ETL/enterprise data warehouse (EDW) by delivering Agile solutions
Develops efficient ETL for loading the data warehouse and makes timely data available for business users
Assists in capturing processes, procedures and other metadata in documentation; ensures that documentation is well organized, complete, and appropriate for the audience
Troubleshoots, supports and maintains the data warehouse and associated tools used by the team
Contributes to and follows best practices established by the governance council, data stewards and enterprise data officer
Develops and improves continuous release and testing processes
Designs, deploys, and manages standardized, centralized data sources for agency reporting
Helps to establish best practices for development, testing, migration and error handling
Implements and maintains business intelligence security best practices including those related to HIPAA
Participates in the training of junior developers
Performs other duties as assigned
REQUIRED EXPERIENCE:
Three (3) years of hands on experience in ETL development (creating automated processes and troubleshooting issues)
Three (3) years of hands on experience moving and manipulating large data sets
Two (2) years of hands on experience dimensional modeling for data warehouses
Preferred Qualifications
Experience in health/life insurance, accounting and financials, or investment data related activities
Experience with data tools (i.e. Alteryx, Visual Studio, SSIS, MSSQL )
Experience with Azure and agile iterations
Experience with ERP applications (i.e. PeopleSoft, Safyr, etc.)
Knowledge of health care claims data
Knowledge, Skills and Abilities
Uses all knowledge, skills, and abilities to apply critical thinking to all aspects of the job. Critical thinking is a process of forming reasoned opinions through observation, information collection, interpretation, analysis, inference, evaluation, and other skills necessary to successfully meet performance standards of the job.
Experience with PeopleSoft HRMS or Finance packages preferred
Experience with ERD Modeling & Maintenance
Knowledge of business intelligence security best practices including those related to HIPAA.
Knowledge of dimensional modeling using star schemas with multiple fact tables
Knowledge of RDBMS architecture and troubleshooting is desirable.
Knowledge of Kimball dimensional models
Knowledge of health care claims data
Knowledge of data mining tools and methods
Knowledge of analytic programming tools and methods (SQL, OLAP, Tableau)
Knowledge or exposure to the R programming language
Professional Expectations:
Attends all meetings, meets delivery deadlines and is available during ERS office hours.
Logs in and remains on agency Jabber during work hours.
Attends remote meetings with camera on unless prior arranged for camera off.
Coordinates leave and vacation with ERS lead.
Must dress appropriately for a business/business casual environment.
Communicates respectfully and works harmoniously with all co-workers, customers and vendors.
Provides exceptional customer service.
Is flexible; able to work under pressure and; able to adapt to change; and able to work on multiple problems and tasks.
Takes initiative to prevent and solve problems.