Information Technology Applications Analyst

At Century Communities, we know it takes hammers and nails to build a house but it also takes passion, vision, integrity and quality to create YOUR home. Everything we do, from selecting locations, designing the architecture and integrating everyday efficiencies into our homes, reflects our deepest consideration and respect for our customers. Century Communities does more than build beautiful homes.

The IT Application Analyst - Reporting/BI position is responsible for design and development of dashboards and reporting, sourced from various data sources. This position will collaborate with Business Stakeholders, Business Leaders, and subject matter experts to design, develop and support Business Intelligence information (reports, data warehouse, dashboards, self-service apps) for Century Communities Inc. This position will gather requirements, perform analysis and translate business reporting requirements to BI Report technical specifications. The Business Intelligence Report/Data Warehouse Developer will design, build and deploy business intelligence reports and dashboards using a variety of front end visualization tools (Power Bi, SSRS, and Excel). The Data warehouse developer is responsible for designing, developing, and maintaining data warehouse and analytics architecture to meet Century’s business analysis and reporting needs. The successful candidate must be able to play multiple roles including data architect, report developer, data warehouse developer, metadata modeler, SQL programmer, and end user trainer/mentor.

* Develop automated reports and dashboards using Power BI, SSRS, Excel and other reporting tools * Gather and understand business requirements to set functional specifications for reporting applications * Develop reports that are formatted to be easily understood and actionable * Maintain the data warehouse infrastructure * Design and implement ETL procedures using SSIS for intake of data from both internal and outside sources; as well as ensure data is verified and quality is checked * Ensure that reports are configured and delivered based on subscriptions * Gather and prepare data from multiple sources to support information analytics * Define or assist with best practices during implementation and integration of Reports Platform * Ability to work in a highly collaborative environment * Provide input to project planning * Perform unit and integration testing and participate in reporting validation and QA efforts as they pertain to reporting and data analytics * Perform the design and extension of data marts and data models * Ensure all data warehouse architecture code is maintained in a version control system * Perform other duties as assigned

**Desired Competencies and Skills:** * Ideally 5 years' experience in data warehouse architecture development and business intelligence * 2+ years' experience creating advanced reports using Microsoft SSRS and Power BI * Expert at developing and testing SSIS packages in SQL Server * Knowledge of SQL with the ability to write complex SQL queries * Understanding of Business Intelligence solutions: operational and analytical, strong knowledge of relational and multi-dimensional database architectures * Strong Power BI application development, including visualization, parameters and report optimization * Homebuilder industry experience **Educational Requirements:** * Bachelor’s degree or commensurate experience