• BI Architect

    Insight Global (Plano, TX)


    Job Description

    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 inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity employer that believes everyone matters. Qualified candidates will receive consideration for employment opportunities without regard to race, religion, sex, age, marital status, national origin, sexual orientation, citizenship status, disability, 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 Human Resources Request Form (https://airtable.com/app21VjYyxLDIX0ez/shrOg4IQS1J6dRiMo) . The EEOC "Know Your Rights" Poster is available here (https://www.eeoc.gov/sites/default/files/2023-06/22-088\_EEOC\_KnowYourRights6.12ScreenRdr.pdf) .

     

    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/ .

    Skills and Requirements

    - 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 null

    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 employment opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment without regard to 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 oruniformed service member status, or any other status or characteristic protected by applicable laws, regulations, andordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or the recruiting process, please send a request to [email protected].