The BI Data Warehouse Architect is responsible for being a key member of our Business Intelligence team, focusing on data architecture, dimensional modeling, platform architecture, solution breakdown, and evangelism of BI best practices and standards. This role is responsible for the design and architecture of the overall BI solution and associated data structures.
Define technical principles, vision, and standards for data within our BI platforms
Effectively and objectively research BI technology concepts and tools, making recommendations to relevant stakeholders
Develop and evangelize standards used within BI, including Data Warehouse(DW) best practices and design patterns, frameworks and templates, naming conventions and coding standards
Develop dimensional modeling best practices, and act as subject matter expert and guide for data models across all areas of the business
Ensure the OW design can scale to handle additional data demands and can adapt to new business questions and data sets
Understand and make recommendations on the underlying hardware and software platforms that host all layers of BI
Define and recommend ETL processes and associated timings
Lend technical expertise to dimensional modeling activities
Support the development and execution of system design reviews and query/code review processes
Help with project-level technical estimates and timelines
Help to establish and improve data governance methodologies
Professional experience with Azure, AWS, V MWare or other Cloud/Virtualization technologies is a plus
Proven Azure BI stack hands-on experience at an enterprise level is a huge plus
Proven DW analysis, design, and data-modeling experience
Expert-level SQL Server experience
Experience working with SSIS, SSRS, SSDT for Visual Studio and related tools
Experience with DAX queries is a plus
Experience with data warehouse/decision support modeling
Experienced at leading dimensional modeling activities, helping to populate the bus matrix, and defining conformed dimensions that will work across multiple data marts
Experience supporting and troubleshooting data flow into front-end BI dashboards
Experience with Agile development methodologies as they apply to BI projects
"MCSE: Cloud Platform and Infrastructure" and/or MCSD: Azure Solutions Architect" certifications are a huge plus
Experience using SQL Server 2016, PowerBI Pro, DQS and MOM 2016
Experience providing data support for predictive analytics projects
Ability to work with C#/.NET
The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.
OpenArc is a technology consulting firm providing industry-leading technical talent placement, software development, and technology strategy services to clients nationwide. Through a unique blending of people and software, OpenArc has a business practice that delivers amazing enterprise, mobile and consumer-facing apps and the best talent for contract, contract-to-hire and direct placements for clients and partners alike.
Staffed with the most-trusted recruiting experts, elite software developers, UI/UX designers and market experts, our team provides clients with the best resources, the right techniques and world-class support resulting in powerful measurable success.