EDW/ Data Warehouse Developer/Programmer Analyst Level: 2
EDW/ Data Warehouse Developer/Programmer Analyst Level: 2
Austin, Texas (candidates who are currently based in Austin or are willing to relocate to the area)
6 months Contract
Essential Work Behaviors:
• 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.
Qualification Requirements
Education/Special Requirements:
• Bachelor’s degree in computer science, engineering, statistics, economics, finance, library science, or related business field.
Experience and Training
• Three (3) years of hands on experience in data warehouse development (i.e. WhereScape, etc.)
• Three (3) years of hands on experience in SQL server ETL development (creating automated processes and troubleshooting issues) using services like SSIS, SSRS, SSAS
• 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
• Three (3) years of hands on experience around documentation of standards, best practices, and governance as it relates to data warehouse development
• Two (2) years of hands on experience in Generative AI and Alteryx
Preferred Qualifications
• Experience in health/life insurance, benefits, accounting and financials, or investment data related activities
• Experience with data tools (i.e. Alteryx, Visual Studio, SSIS, MSSQL, WhereScape )
• Experience with Azure and agile iterations
• Experience with ERP applications (i.e. PeopleSoft, Safyr, etc.)
• Knowledge of health care claims data (i.e. HIPAA data)
• Experience troubleshooting performance in SQL servers
• Experience with development and troubleshooting of Alteryx workflows
Knowledge, Skills and Abilities
• Applies critical thinking skills to all aspects of the job, utilizing knowledge, skills, and abilities to form reasoned judgments. Critical thinking involves observing, gathering information, interpreting data, analyzing situations, making inferences, evaluating outcomes, and employing other essential skills required to successfully meet job performance standards.
• 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, Oracle, Tableau, Alteryx)
• Knowledge or exposure to the R programming language
