Data Warehouse Architect - CirrusLabs

Our client is seeking an experienced Data Warehouse Architect with Healthcare experience for a hybrid contract-to-hire role based in Southeast Florida. Fully remote candidates will be considered on a case-by-case basis.

The Data Warehouse Architect is responsible for designing and developing projects using complex T-SQL language, complex Microsoft SQL Server Integrated Services, Microsoft SQL Server Analysis Services, Microsoft Power BI and Microsoft SQL Server Reporting Services. They are also responsible for defining, developing, and delivering data and analysis using Business Intelligence best practices, along with Data Warehousing experience, to build Analytics Tabular Models and OLAP Models which will enable various business teams to make critical business decisions.

Responsibilities:

• Leads and implements projects and initiatives to develop new systems, methods and tools to gather, process, analyze, and publish BI data from multiple sources.
• Leads and mentors Business Intelligence team to develop an understanding of each business department's role within the company and works closely with management teams to determine needs.
• Works closely with IT Manager, Business Intelligence, Data Warehousing team, Business Units and Business Stakeholders to understand their unique analytic and reporting requirements to assist in the development of metrics, reports, dashboards and visualizations.
• Leads and creates process, reports and/or analytic models using various SQL Server technologies such as Visual Studios Data Tools; Relational Database and complex T-SQL Language; Extraction, Transformation and Loading (ETL) (Microsoft SQL Server Integrated Services (SSIS)) and/or Analytics/OLAP Cube and Tabular Model Development (Microsoft SQL Server Analysis Services (SSAS) and MDX)
• Actively leads projects with BI reporting development life cycle, including identifying Subject Matter Experts; Requirement Gathering; Analysis, Design and Development; and Testing, Implementation and Go Live Support
• Provides individual contributions after key projects have been implemented and works closely with the IT Manager and Business Intelligence to proactively identify data quality issues, coordinate root cause analysis, implement required fixes, and perform QA validations to build exception reporting where needed.
• Provides management with project status updates, feedback, and appropriate reporting on key responsibilities and objectives, along with preparation of monthly project scorecard reports.
• Maintains professional and technical knowledge by attending educational workshops, reviewing professional publications, establishing personal networks, benchmarking state-of-the-art practices, and participating in professional societies.

Qualification Requirements:

• Bachelor's degree (B. A. / B. S.) from four-year College or university or ten (10) years' experience in IT field
• Experience with clinical and financial systems within a Healthcare environment
• Minimum of ten (10) years' hands on experience in various SQL Server technologies in Visual Studios Data Tools; Relational Database and complex T-SQL Language; and Extraction, Transformation and Loading (ETL) (Microsoft SQL Server Integrated Services (SSIS)
• Minimum of ten (10) years' hands on experience development of Analytics/OLAP Cube and Tabular Model Development (Microsoft SQL Server Analysis Services (SSAS) and MDX)
• Minimum of ten (10) years' experience in report development using Microsoft SQL Server Reporting Services
• Minimum of five (5) years' experience in analytical report/dashboard using tools such as Microsoft Power BI
• Experienced in Data Warehouse/Solution Design and Dimensional Modeling (Kimball Methodology)
• Experience with Data Warehousing and OLAP Models; and defining, developing, and delivering data and analysis
• Experience with Azure Data & Analytics PaaS Services: Azure Data Factory, Azure Data Lake, Azure Synapse Analytics, Azure Databricks, Azure HDInsight + Spark, Azure Databricks, and Azure SQL DB
• Experience with cloud data warehouse platform
• Experience in turning business use cases and requirements into technical solutions.
• Experience in business process mapping of data and analytics solutions

Preferred Qualifications:

• Experience with preparing data for Data Science and Machine Learning purposes
• Experience with Machine Learning and Artificial Intelligence solutions
• Knowledge of distributed systems and data processing frameworks such as Lambda architecture patterns
• Microsoft Certifications: Power BI Data Analyst Associate, Azure Data Engineer Associate, Azure Enterprise Data Analyst Associate etc.
• EPIC Certifications in Tapestry Modules
• Knowledge of Master Data Management (MDM) and Data Quality tools
• Strong customer service focus and sense of urgency.
• Excellent skills in problem analysis and abstraction.
• Self-motivated and quick learner of new technology.
• Ability to thrive and produce results with little or no supervision in a fast-paced, entrepreneurial environment.

Skills and Abilities:

• Proficient in Data Warehouse/Solution Design and Dimensional Modeling (Kimball Methodology)
• Proficient understanding of Business Intelligence best practices; experience with Data Warehousing and OLAP Models; and defining, developing, and delivering data and analysis
• Ability to lead and mentor team members to improve accuracy and quality of projects.
• Well-organized, action and results oriented team player with exceptional time management skills to support multiple initiatives simultaneously in a fast-paced environment with excellence in planning and execution.
• Proven ability to establish and articulate a vision, set goals, develop, and execute strategies, and track and measure results with high attention to detail and the ability to prioritize.
• Ability to combine strong analytical skills with business knowledge to develop rapport with key customers in the business and approach every challenge with a customer-centric view.
• Ability to adhere to coding standards and participate in peer code reviews.
• Knowledge of project management methodologies and best practices
• Excellent presentation skills with solid communication capabilities and practices, both oral and written
• Ensure systems comply with HIPPA regulations.