Business Intelligence Analyst Architect

hace 3 semanas

Saltillo, México Johnson Controls A tiempo completo

**Job Details****What will you do?**The IT Business Intelligence Architect will be a key player for creating, maintaining and optimizing SQL server queries, stores procedures and database tables used as a source for reporting, analytics and dashboards in the Financial Reporting and Analysis (FP&A) organization.This role requires strong technical and analytical skills to build best in class reporting and analytics platform that will support financial decision making.**How will you do it?**:- Develop Data Warehouse architecture and supporting data model- Establish and maintain ETL processes- Ensure data quality and integrity- Develop, implement and optimize DTSX packages using Microsoft Integration Services- Implement DWH / BI improvements (architecture, OLAP, DevOps, etc.)- Create reports and dashboards in Power BI- Automate process- Create and maintain technical documentation- Supports and troubleshoots service requests and monitor system stability and performance**What we look for?**:- Bachelor degree from an accredited university- Fluent English- 3 or more years of experience with designing, developing and deploying of relational databases (SQL) and Business Intelligence solutions- Background in troubleshooting SQL Server performance and analyzing query execution plans- Strong T-SQL knowledge and skills- Strong experience with ETL tools and ability to extract data from various data sources (MS SQL, Oracle, Hadoop, CSV, Excel, Access)- 3 years of experience with SQL Server Integration Services- Proficient knowledge of 2 or more programming languages.- Experience with Microsoft Power BI or similar platforms (MicroStrategy, IBM Cognos, Tableau, etc.)- ERP or other data source experience, with an understanding of business processes, design and data flows around source systems- Demonstrated ability to learn new technologies as requiredDesired:- Basic knowledge of project management techniques (PMI, Agile, Scrum, etc)- Knowledge of Microsoft Office 365 suite for development (SharePoint, Flows, Power Apps, etc)- Predictive analytics background a big advantage- HFM / ESSBASE- OneStream- Financial background is a plus.- "Johnson Controls does not request pregnancy or HIV testing as a requirement for admission, permanence or promotion"Johnson Controls values a diverse and inclusive workplace.Providing this information will help us to ensure our recruitment practices promote equality of opportunity.Your response to the self-identification questionnaire below is voluntary.It is however mandatory to answer the questions, even if you choose not to provide the information.The information will be kept anonymous and your answer will be treated with the strictest confidence and protected from misuse.We assure you that your answers will be used only for the purposes of monitoring our equal opportunities policy and will not be used by us to make any unlawful decisions affecting you, whether in a recruitment exercise or during the course of any employment with us.**You are not obliged to provide this information and you will not suffer any penalty if you choose not to do so.

  • Business Intelligence Analyst

    hace 2 semanas

    Saltillo, México Joyson Safety Systems A tiempo completo

    **Business Intelligence Analyst** Do you have a passion for data? Are you a KPI Driven Professional? Would you like to work in a Global Company that strives to provide Safety System Solutions of the highest quality and reliability that allow our customers the design freedom and confidence to drive the next generation in mobility? The BI Analyst is a...

  • Business Intelligence Analyst

    hace 2 semanas

    Saltillo, México Joyson Safety Systems A tiempo completo

    **Business Intelligence Analyst** Do you have a passion for data? Are you a KPI Driven Professional? Would you like to work in a Global Company that strives to provide Safety System Solutions of the highest quality and reliability that allow our customers the design freedom and confidence to drive the next generation in mobility? The BI Analyst is a...

  • Business Intelligence Analyst Architect

    hace 4 semanas

    Saltillo, México Johnson Controls A tiempo completo

    **Job Details****What will you do?**The IT Business Intelligence Architect will be a key player for creating, maintaining and optimizing SQL server queries, stores procedures and database tables used as a source for reporting, analytics and dashboards in the Financial Reporting and Analysis (FP&A) organization.This role requires strong technical and...

  • Business Intelligence Analyst Architect

    hace 2 días

    Saltillo, México Johnson Controls A tiempo completo

    **Job Details** **What will you do?**The IT Business Intelligence Architect will be a key player for creating, maintaining and optimizing SQL server queries, stores procedures and database tables used as a source for reporting, analytics and dashboards in the Financial Reporting and Analysis (FP&A) organization. This role requires strong technical and...

  • Business Intelligence Analyst

    hace 3 semanas

    Saltillo, México Johnson Controls A tiempo completo

    **Job Details****What will you do?**The Business Intelligence Analyst collects and coordinates business requirements for analytical reporting.Monitors the performance of reports and dashboards, completes data validations, resolves data integrity issues and develop/enhance processes with simplification or automation.Provides BI system user support through...

  • Business Intelligence Analyst

    hace 4 semanas

    Saltillo, México Johnson Controls A tiempo completo

    **Job Details****What will you do?**The Business Intelligence Analyst collects and coordinates business requirements for analytical reporting. Monitors the performance of reports and dashboards, completes data validations, resolves data integrity issues and develop/enhance processes with simplification or automation. Provides BI system user support through...

  • Business Intelligence Analyst Jr

    hace 2 semanas

    Saltillo, México Johnson Controls A tiempo completo

    **Job Details**What will you do?The Business Intelligence Analyst collects and coordinates business requirements for analytical reporting. Monitors the performance of reports and dashboards, completes data validations, resolves data integrity issues and develop/enhance processes with simplification or automation. Provides BI system user support through...

  • Senior Business Intelligence Analyst

    hace 3 semanas

    Saltillo, México Johnson Controls A tiempo completo

    **Job Details****What you will do?**The Business Intelligence Analyst collects and coordinates business requirements for analytical reporting. Monitors the performance of reports and dashboards, completes data validations, resolves data integrity issues and develop/enhance processes with simplification or automation. Provides BI system user support through...

  • Sr Business Intelligence Analyst

    hace 3 semanas

    Saltillo, México Johnson Controls International A tiempo completo

    **Who we are**:**Overview**The role of a GP Data and Analytics Analyst at Johnson Controls is pivotal in extracting valuable insights from data, enabling informed decision-making, and driving our organizational growth. This position involves collecting, analyzing, and interpreting data to provide actionable recommendations. If you’re driven by the...

  • Intelligence Analyst

    hace 2 semanas

    Saltillo, México Orange Company A tiempo completo

    **WE CREATE THE AMAZING!**En Orange Investments siempre estamos buscando al mejor talento, aquel que se preocupa no solo por él o ella misma, sino que busca empatar sus talentos para crear una mejor sociedad.Desde que comenzamos, imaginamos una atmósfera de transparencia, apertura, trabajo duro y diversión sana mientras trabajamos y cumplimos con nuestras...