BI Architect

• Insight Global is seeking a Business Intelligence Architect to plan the architecture and solution design of enterprise data warehouses/data marts and reporting as part of a collection of systems in a large technology ecosystem. You will be the guide for architectural principles and standards.
The Day-to-Day:
• Be a trusted advisor for our internal clients by designing and building analytics cloud solutions to promote better outcomes
• Deliver architectures for transformation and modernization of enterprise data solutions using Azure cloud data technologies
• Analyze current business processes and identify relevant Microsoft Azure Data & Analytics IaaS, SaaS and PaaS services
• Help use data-driven insights to help our clients achieve outcomes and goals while respecting security requirements
• Design and build data pipelines, data streams, reports, information dashboards, data services APIs, data generators and other data-relevant services
• Work across client partners to gather solution requirements and propose architecture decisions
• During implementation collect, aggregate, transform, load and analyze structured/unstructured data from multiple internal and external sources
• Have a sound understanding of usage cost drivers in Azure cloud-based solutions
• Manage end-to-end delivery by Investigating problem areas, working with product manager and other partners
• Develop and maintain data warehouse schematics, layouts, architectures and relational/non-relational databases for data access and Advanced Analytics
• Define effective metrics for data monitoring processes. Knowledge of DevOps processes (including CI/CD) and Infrastructure as Code fundamentals
• Be a critical part of the data supply chain, ensuring that partners can access and manipulate data for routine and ad hoc analysis to improve results using Advanced Analytics

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to HR@insightglobal.com.To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/.

- 10+ years of hands on T-SQL Experience, nothing less than 10 years! (Writing queries, building stored procedures, performance optimization, etc.)
- 4+ years of Azure Synapse Serverless pool
- 3+ years of experience building large scale design, implementation, and operations of OLTP, OLAP, DW and NoSQL data storage technologies such as SQL Server, Azure SQL, Azure SQL DW, PostgreSQL, Cosmos DB, Redis Cache, Azure Data Lake, Azure Stream Analytics, Event Hubs, Databricks, Python, Scala, or Power BI
- 2+ years of Experience as a BI Architect
o Azure SQL Data Warehouse (Synapse)
o ADF – building pipelines

Benefit packages for this role will start on the 31st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.