Under minimal supervision, participates in the systems development life cycle for new development, enhancements and maintenance projects in multiple Data Warehouses
Works closely with business leaders, end users and other technical resources to design and implement data and analytic solutions to enhance the business decision making process.
Designs, develops and deploy ETL and data visualization software needed to prepare and deliver information in support a variety of business needs.
Develop and support end to end Data Warehouse, Business Intelligence and Advanced Analytics solutions for analytics and management teams (25%)
Responsible for designing, building, and supporting the components of data warehouse, such as ETL processes, databases, analytic marts and analytics environments, and other critical data pipelines (20%)
Collaborates with the business analyst, user community, and other technical resources to thoroughly document requirements and detailed technical designs for software solutions based on functional requirements from the different business users (15%)
Studies and understands the company’s business processes and applications, including their effect on data and analytics, and applies the knowledge gained in designing solutions to meet analytics needs (10%)
Designs relational, dimensional and analytical models in accordance with best practices (10%)
Perform code reviews, data validation, and system testing for data warehouse changes while establishing system documentation and ensuring it is continually sustained (10%)
Interact closely with members of both IT and the business (10%)

Requirements

Bachelor's Degree Information Technology, Computer Science, or related field required
Seven year's experience in the analysis, design, implementation, and support of complex applications
4-6 years BI Solutions
Expertise with Microsoft BI stack, including SQL Server 2008/2008R2, SSIS, SSRS, SSAS, Performance Point, Power Pivot, Share Point, Report Builder, and MDX.
Other data warehousing and business intelligence skills desired: master data management, data modeling, hardware/software architecture, data cleansing and quality, dashboard and scorecard development, third-party reporting platforms, and performance tuning.

Benefits

Outstanding benefits including up to 27 paid days off per year
Immediate retirement plan employer contribution up to 9.5%
Generous medical plans
Free RTD EcoPass (public transportation)
On-site employee fitness center and wellness classes
Childcare discount programs & exclusive perks on large brands, travel, and more
Tuition reimbursement & assistance
Education & development opportunities including career pathways and coaching
Professional clinical advancement program & shared governance
Public Service Loan Forgiveness (PSLF) eligible employer+ free student loan coaching and assistance navigating the PSLF program
National Health Service Corps (NHCS) and Colorado Health Service Corps (CHSC) eligible employer

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

ETLdata visualizationdata warehousingBusiness IntelligenceAdvanced Analyticsdata modelingdata cleansingperformance tuningSQLMDX

Soft Skills

collaborationdocumentationanalytical thinkingproblem solvingcommunication