*job details*
*responsibilities*:
the senior analyst (reporting & analytics), enterprise end-user services is responsible for analyzing bi (business intelligence) needs of the it area and recommending bi and analytics solutions and strategy.
you will develop and support the eus (end user services) bi platform.
knowledge of ms bi stack - power bi, power bi administration, ssrs (sql server reporting services), ssas (sql server analysis service), power apps and power automate.
accountable to improve the reliability of the key reports, tools, dashboards, etl (extract, transform, and load) processes (extract, transform and load), and apps our team supports.
define and implement database specifications standards to ensure consistency, quality, and excellence in data outputs or reports.
*guidelines*:
- responsible for enterprise-grade analytics solutions for it customers.
- develop and maintain bi infrastructure architectural design and technical configurations.
- provide frameworks, reference architectures & accurate estimates for the implementations.
- set up documentation for policies, best practices, standards, and procedures (workflows) for reporting systems and services.
- understand data standards and identify data abnormalities.
instill data quality in all solutions delivered.
- design and develop scorecards and dashboards using power bi, ssas, ssrs and other related technologies.
- develop overall project technical design and build custom elements of a project.
- support operational excellence and six sigma activities by performing analysis where needed.
build data models and formulate decision or predictive models that relate operational activities to results and drive continuous improvement.
- create new reports or modify existing reports using industry standards and best practices.
- engage with it to understand the impact of new system development or changes to reporting.
- maintain close alignment with all customers (internal, external, management and at the field level).
- interact with other reporting teams and sme(s) to ensure collaboration.
*requirements*:
- bachelor's degree or higher from an accredited university in engineering, it, economics, math, statistics, science, or other related fields
- 3+ years in a developer-level role in microsoft bi stack
- experience in performance tuning of power bi reports/dashboards, scheduling reports/direct query etc.
- knowledge of power bi set up and deployment architecture design.
gateway administration
- in-depth experience with microsoft analytics stack (sql server, power bi, power query, dax, and sql)
- advanced knowledge power bi reports creation
- proficient in dax, m language
- experience in extraction, transformation and loading (ssis (sql server integration service))
- implementation of access control and knowledge of security mechanisms for report access
- experience with cube development using ssas
- proficiency required with microsoft automate and microsoft power apps setup and usage
- knowledge of dimensional modelling and data warehousing concepts
- proficient in microsoft office suite and o365
- superior documentation and organizational skills.
must be detail oriented
- excellent critical-thinking skills with the ability to research and analyze data retrieved from multiple sources
- must possess and demonstrate excellent verbal, written, and interpersonal communications skills
- must be an adaptable self-starter and work with mínimal supervision.
must be able to handle multiple projects and organize time effectively.
- must be willing to put in extra time and effort if necessary.
go beyond the requirements of the job and strive to exceed expectations
- johnson controls does not request pregnancy or hiv testing as a requirement for admission, permanence or promotion.
_
li-jc1