Johnson Controls

Johnson Controls

Reporting Data Analyst REMOTE at Johnson Controls in Irving, TX

Irving, TX | $80K - $100K

Apply for job

Qualifications

  • This person will have experience working on complex, enterprise projects
  • Minimum 5 years of experience in related business analyst or data/reporting analyst roles
  • Excellent skill level in SQL, PL/SQL
  • In-depth experience with Microsoft analytics Stack (SQL Server, SSAS Tabular, Power BI, Power Query, DAX, SQL and T-SQL)
  • Advanced knowledge Power BI
  • Proficient in DAX, M language
  • Experience in Extraction, and Transformation and Loading (SSIS)
  • Experience in Tabular/OLAP Model (Microsoft SSAS)
  • In-depth experience with Associated Development Tools - DevOps, Visual Studios Data Tools, SQL Server Management Studio, SQL Server Data Tools, Microsoft TFS
  • Knowledge of working with database client tools such as Toad
  • Experience with Azure Machine Learning (AML)
  • Database Design
  • Excellent skill level in relational database required
  • Oracle, MS SQL Server knowledge
  • 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 minimal supervision
  • Must be able to handle multiple projects and organize time effectively
  • Must be willing to put in extra time and effort if need be
  • Data Science & Machine LearningEstimated Salary: $20 to $28 per hour based on qualifications

Responsibilities

  • The Senior Analyst will be responsible for designing holistic Business Intelligence and Analytic solutions, tools, and products
  • As a Senior Analyst on the team, you will be on the forefront of solutioning, hands-on data discovery, and unifying analytics across the organization
  • In this role you are expected to be hands-on throughout the life cycle of a solution and engage with other teams, departments, and stakeholders
  • The Senior Analyst will handle complex projects utilizing multiple tools and technologies to deliver quality products such as ad-hoc data discovery requests, dashboards and scorecards, forecasting models and automated solutions
  • Build relationships to understand the needs of our customers in a variety of business domains to provide deep insights and business decisions
  • Provide coaching and guidance on analytical modeling, data science best practices and methodologies to internal teams
  • Design and develop tools and products that bring advanced analytic methodologies and models to both analytics team and customers. focused on quality and customer experience
  • Create scalable deliverable solutions such as scorecards and dashboards using Power BI and other data visualization tools for various organizational metrics and KPIs
  • Perform ad-hoc exploratory analysis
  • Elicit business requirements from Subject Matter Experts using interviews, document analysis and user story workshops
  • Perform statistical analysis, build predictive models, and formulate decision models that relate operational activities to results; to drive value stream enhancement and continuous improvement
  • Understand data standards and identify data abnormalities
  • Instill data quality in all solutions delivered

Benefits

  • $80K -- $100K

Company information

Linkedin Icon