Data Warehouse Architect

Pleasant Consulting • St. Paul, MN

16d

About The Position

· Architect, design, build, implement, and maintain solutions to meet global business needs for the data warehouse and data mart environments using the Microsoft BI/DW stack and Azure based tools · Work with other architects, BI director, and the business to define the architecture and strategy for BI/DW across the commercial digital solutions environment · Provide technical direction to ETL developers, BI developers, and application developers to architect, design, and implement solutions · Stay current on the technology, tools, and approaches in the BI/DW/Analytics/Data Visualization frameworks /cloud space · Solve complex problems and develops proofs of concept to validate ideas or technologies · Work on multiple initiatives simultaneously · Create and own best practice standards and templates · Help support the system and troubleshoots system related issues

Requirements

• Bachelor’s degree in Information Technology or related field
• 8 years of experience in Information Technology
• 5 years of experience architecting, designing, and developing BI/Data Warehouse solutions. using primarily the Microsoft BI/DW stack e.g. SQL DW, ADLS, Snowflake, SQL Server, ADF, SSAS tabular, Power BI, Paginated reports, Azure data explorer (Kusto)
• Experience developing custom data visualizations and API’s in tools like Angular/Angular JS, D3, Highcharts, etc.
• 5 years of experience working with SQL, SQL stored procedures, Change data capture, and relational/multidimensional databases
• 3 years of experience with Azure cloud development
• Experience with Big Data solutions such as data lakes, IOT, advanced analytics/data science, etc.
• No immigration sponsorship available for this opportunity

Nice To Haves

• Master’s degree in Information Technology
• Proven ability to quickly learn new technologies
• Knowledge of service data and service-based businesses
• Experience with agile methodologies
• Strong problem-solving orientation
• Can manage multiple competing tasks/projects at the same time
• Strong team and customer service focus

Responsibilities

• Architect, design, build, implement, and maintain solutions to meet global business needs for the data warehouse and data mart environments using the Microsoft BI/DW stack and Azure based tools
• Work with other architects, BI director, and the business to define the architecture and strategy for BI/DW across the commercial digital solutions environment
• Provide technical direction to ETL developers, BI developers, and application developers to architect, design, and implement solutions
• Stay current on the technology, tools, and approaches in the BI/DW/Analytics/Data Visualization frameworks /cloud space
• Solve complex problems and develops proofs of concept to validate ideas or technologies
• Work on multiple initiatives simultaneously
• Create and own best practice standards and templates
• Help support the system and troubleshoots system related issues

What This Job Offers

• Job Type: Full-time