Business Intelligence Analyst

1 week ago


Milwaukee, United States Johnson Controls International Full time

**Build your best future with the Johnson Controls team**

As a global leader in smart, healthy and sustainable buildings, our mission is to reimagine the performance of buildings to serve people, places and the planet. Join a winning team that enables you to build your best future Our teams are uniquely positioned to support a multitude of industries across the globe. You will have the opportunity to develop yourself through meaningful work projects and learning opportunities. We strive to provide our employees with an experience, focused on supporting their physical, financial, and emotional wellbeing. Become a member of the Johnson Controls family and thrive in an empowering company culture where your voice and ideas will be heard - your next great opportunity is just a few clicks away

**What we offer**

**Competitive salary**

Paid vacation/holidays/sick time - **15 days of vacation first year**

Comprehensive benefits package including 401K, medical, dental, and vision care - **Available day one**

Encouraging and collaborative team environment

Dedication to safety through our Zero Harm policy

JCI Employee discount programs (The Loop by Perk Spot)

**What will you do**

The IT Business Intelligence Analyst 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 required

Desired:

- 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

LI-Hybrid

LI-KP



  • Milwaukee, United States MARCUS CINEMAS OF WISCONSIN LLC Full time

    JOB REQUIREMENTS: Description Marcus Theatres Position Description - Business Intelligence Analyst Broad Description of Duties: Design, develop and maintain strategic business information systems, including system requirement assessment along with the full development life cycle.Primary focus is on business intelligence development, information delivery...


  • Milwaukee, United States MCW: SARGEANT HEALTH CENTER Full time

    JOB REQUIREMENTS: Position Description: We're looking for those individuals-the creative thinkers and innovation seekers-who are content with nothing short of changing the world. Discover the endless opportunities within the Medical College of Wisconsin (MCW) and be inspired by the work we can do together to improve health, and make a positive, daily impact...


  • Milwaukee, United States ADVENT Full time

    Envision a place where you thrive. Envision an organization that believes in you as much as you believe in them. A place where your work has meaning. At ADVENT, you can have just that. ADVENT embraces those who seek more and demand excellence from themselves and their employer. We invite you to be challenged, to challenge, and to embark on a journey where...


  • Milwaukee, Wisconsin, United States Medical College of Wisconsin Full time

    Position Description:We're looking for those individuals-the creative thinkers and innovation seekers-who are content with nothing short of changing the world. Discover the endless opportunities within the Medical College of Wisconsin (MCW) and be inspired by the work we can do together to improve health, and make a positive, daily impact in our...


  • Milwaukee, United States ADVENT Full time

    Job DescriptionJob DescriptionDescription:Envision a place where you thrive. Envision an organization that believes in you as much as you believe in them. A place where your work has meaning. At ADVENT, you can have just that.ADVENT embraces those who seek more and demand excellence from themselves and their employer. We invite you to be challenged, to...


  • Milwaukee, United States Johnson Controls Full time

    **What you will do** Johnson Controls embraces customer focus, tenacious problem-solving, data-driven decision making and collaboration. The Sales Intelligence Analyst based in Milwaukee, WI, will contribute to this positive culture! You will design, develop and deploy commercial analytic tools aligned with key business initiatives to drive sales behaviors...


  • Milwaukee, United States Johnson Controls Full time

    JOB REQUIREMENTS: What you will do Johnson Controls embraces customer focus, tenacious problem-solving, data-driven decision making and collaboration.The Sales Intelligence Analyst based in Milwaukee, WI, will contribute to this positive culture! You will design, develop and deploy commercial analytic tools aligned with key business initiatives to drive...


  • Milwaukee, United States Johnson Controls Full time

    JOB REQUIREMENTS: What you will do Johnson Controls embraces customer focus, tenacious problem-solving, data-driven decision making and collaboration.The Sales Intelligence Analyst based in Milwaukee, WI, will contribute to this positive culture! You will design, develop and deploy commercial analytic tools aligned with key business initiatives to drive...


  • Milwaukee, United States Conduent Business Services Full time

    The Senior Business Analyst will lead business analysts in the identification of system requirements, development of use cases and story lines, requirements traceability, and functional design of modern complex systems.  Responsibilities Working directly with end users to identify the requirements and functionality needed in systems.  ...


  • Milwaukee, Wisconsin, United States Conduent Business Services Full time

    The Senior Business Analyst will lead business analysts in the identification of system requirements, development of use cases and story lines, requirements traceability, and functional design of modern complex systems. Responsibilities Working directly with end users to identify the requirements and functionality needed in systems. ...


  • Milwaukee, United States Johnson Controls International Full time

    **Build your best future with the Johnson Controls team** As a global leader in smart, healthy and sustainable buildings, our mission is to reimagine the performance of buildings to serve people, places and the planet. Join a winning team that enables you to build your best future! Our teams are uniquely positioned to support a multitude of industries...


  • Milwaukee, United States Clarios Full time

    What you will do This position exists within the Category Management team of Clarios. The Market Intelligence Analyst will play a valuable role in building strong relationships with Clarios stakeholders and aftermarket customers by providing strategic, consultative guidance through consumer, industry and market data intelligence. This individual will...


  • Milwaukee, Wisconsin, United States Clarios Full time

    What you will doThis position exists within the Category Management team of Clarios.The Market Intelligence Analyst will play a valuable role in building strong relationships with Clarios stakeholders and aftermarket customers by providing strategic, consultative guidance through consumer, industry and market data intelligence. This individual will deliver...


  • Milwaukee, Wisconsin, United States Clarios Full time

    What you will doThis position exists within the Category Management team of Clarios.The Market Intelligence Analyst will play a valuable role in building strong relationships with Clarios stakeholders and aftermarket customers by providing strategic, consultative guidance through consumer, industry and market data intelligence. This individual will deliver...


  • Milwaukee, United States Northwestern Mutual Full time

    **At Northwestern Mutual, we are strong, innovative and growing. We invest in our people. We care and make a positive difference.**: **This position is open to remote. However, if local to MKE or NYC, it will require some onsite presence each week (3 days in MKE or 2 days in NYC).** **At Northwestern Mutual, we believe relationships are built on trust....


  • Milwaukee, United States HCL Technologies Full time

    Job Description (Posting). Job Description: We are seeking a highly skilled and experienced BI AnalystPower-BI developer with at least 5-7 years of hands-on development experience using PowerBI. As a contractor, you will be responsible for leveraging PowerBI's capabilities to analyze and visualize complex data in a meaningful and actionable way for our...


  • Milwaukee, United States Vanguard Intelligence & Security Group Full time

    Job DescriptionJob DescriptionVanguard Intelligence & Security Group in Milwaukee, WI is looking for special event security officers/drivers to join our team. We are located on 2266 N Prospect Ave Suite 514, in Milwaukee, WI. Our ideal candidate is attentive, ambitious, and hard-working.BenefitsCompetitive PayNetworking OpportunitiesProfessional...

  • Business Analyst

    4 weeks ago


    Milwaukee, United States TeamSoft Full time

    TeamSoft IT Solution’s client is looking for a contract-to-hire Business Analyst. This position is hybrid in Germantown, WI. Business Analyst Job Summary: Identify and communicate with key project stakeholders to develop analyses and documentation collaboratively, communicating effectively and efficiently with production, managerial, and executive...

  • Business Analyst

    1 month ago


    Milwaukee, United States TeamSoft Full time

    TeamSoft IT Solution’s client is looking for a contract-to-hire Business Analyst. This position is hybrid in Germantown, WI. Business Analyst Job Summary: Identify and communicate with key project stakeholders to develop analyses and documentation collaboratively, communicating effectively and efficiently with production, managerial, and executive...

  • Business Analyst

    4 weeks ago


    Milwaukee, United States TeamSoft Full time

    TeamSoft IT Solutions client is looking for a contract-to-hire Business Analyst. This position is hybrid in Germantown, WI. Business Analyst Job Summary: Identify and communicate with key project stakeholders to develop analyses and documentation collaboratively, communicating effectively and efficiently with production, managerial, and executive teams....