Company:
Integrated Resources, Inc
Location: Brea
Closing Date: 21/10/2024
Hours: Full Time
Type: Permanent
Job Requirements / Description
Hybrid. 1-2 days in office on average " Hours Per Week: M-F " Shift Time: 8:00AM - 5:00PM PST The top 3 must-haves are as follows: 1. Advanced-Data Modeling and DAX Proficiency: Expertise in building complex data models, including star and snowflake schemas. Strong command of Data Analysis Expressions (DAX) for creating calculated columns, measures, and advanced analytical functions. 2. Power BI Service and Administration Skills: Experience with the Power BI Service, including managing workspaces, sharing reports, and setting up data refresh schedules. Understanding of Power BI security features, such as row-level security (RLS) and managing user permissions. 3. Integration and Data Connectivity: Proficiency in connecting Power BI to various data sources, such as SQL Server, Azure, Excel, and APIs. Ability to work with Power Query for data transformation, including ETL (Extract, Transform, Load) processes, and handling large datasets efficiently.
Description/Comment:In this role, you will have the opportunity to:
Be part of a team of highly skilled technical analysts, software engineers and Oracle experts who are accountable for timely, high-quality solution delivery across North America and Europe Client Services organizations. Provide production support for critical platforms and reporting tools to include work focusing on applications and data warehouses. Engage with Client Service leadership for developing and delivering on the vision and strategic plans for support infrastructure and capacity in areas of resourcing, process optimization and tool development. Lead, participate and deliver ideation and Product definition workshops, value proposition and business cases, as well as functional roadmaps and project plans in close alignment with organizational objectives. Help implement strategy and roadmap for Client Services reporting and application infrastructure, including analysis support. Assist in efforts by the team to streamline and automate the collection, management, and analysis of data for the benefit of the business. Work in cross-functional teams to tackle complex company-wide goals and deliver meaningful results. The essential requirements of the job include bachelor s degree with 5+ years of experience OR Master s Degree with 3+ years of experience, Experience with project management principles. Continuous improvement experience. Strong analytical skills. Working knowledge of ERP systems, such as Oracle EBS or equivalent (SAP, Sage, etc.) Required experience with relational databases and SQL languages, such as SQL Server, Oracle, and MySQL. Experience with ETL tools, such as SQL Integration Services (SSIS) and/or Informatica Cloud. Required experience in data visualization tools, such as SQL Reporting Services (SSRS), PowerBI, OBIEE, Spotfire, Tableau or equivalent. Experience automating business process with tools such as MS Power Automate and/or UI Path Studio. It would be a plus if you also possess previous experience in: Experience with the following: Smartsheet, Access Databases, SharePoint, VM Server management and basic maintenance. Experienced with Python development, Web development experience, such as HTML, PHP, Java or equivalent, Experience with Oracle APEX (Application Express). 3-5 year s experience required.
Additional Job Details:o Hybrid. 1-2 days in office on average " Hours Per Week: M-F " Shift Time: 8:00AM - 5:00PM PST
Hybrid. 1-2 days in office on average " Hours Per Week: M-F " Shift Time: 8:00AM - 5:00PM PST The top 3 must-haves are as follows: 1. Advanced-Data Modeling and DAX Proficiency: Expertise in building complex data models, including star and snowflake schemas. Strong command of Data Analysis Expressions (DAX) for creating calculated columns, measures, and advanced analytical functions. 2. Power BI Service and Administration Skills: Experience with the Power BI Service, including managing workspaces, sharing reports, and setting up data refresh schedules. Understanding of Power BI security features, such as row-level security (RLS) and managing user permissions. 3. Integration and Data Connectivity: Proficiency in connecting Power BI to various data sources, such as SQL Server, Azure, Excel, and APIs. Ability to work with Power Query for data transformation, including ETL (Extract, Transform, Load) processes, and handling large datasets efficiently.
Description/Comment:In this role, you will have the opportunity to:
Be part of a team of highly skilled technical analysts, software engineers and Oracle experts who are accountable for timely, high-quality solution delivery across North America and Europe Client Services organizations. Provide production support for critical platforms and reporting tools to include work focusing on applications and data warehouses. Engage with Client Service leadership for developing and delivering on the vision and strategic plans for support infrastructure and capacity in areas of resourcing, process optimization and tool development. Lead, participate and deliver ideation and Product definition workshops, value proposition and business cases, as well as functional roadmaps and project plans in close alignment with organizational objectives. Help implement strategy and roadmap for Client Services reporting and application infrastructure, including analysis support. Assist in efforts by the team to streamline and automate the collection, management, and analysis of data for the benefit of the business. Work in cross-functional teams to tackle complex company-wide goals and deliver meaningful results. The essential requirements of the job include bachelor s degree with 5+ years of experience OR Master s Degree with 3+ years of experience, Experience with project management principles. Continuous improvement experience. Strong analytical skills. Working knowledge of ERP systems, such as Oracle EBS or equivalent (SAP, Sage, etc.) Required experience with relational databases and SQL languages, such as SQL Server, Oracle, and MySQL. Experience with ETL tools, such as SQL Integration Services (SSIS) and/or Informatica Cloud. Required experience in data visualization tools, such as SQL Reporting Services (SSRS), PowerBI, OBIEE, Spotfire, Tableau or equivalent. Experience automating business process with tools such as MS Power Automate and/or UI Path Studio. It would be a plus if you also possess previous experience in: Experience with the following: Smartsheet, Access Databases, SharePoint, VM Server management and basic maintenance. Experienced with Python development, Web development experience, such as HTML, PHP, Java or equivalent, Experience with Oracle APEX (Application Express). 3-5 year s experience required.
Additional Job Details:o Hybrid. 1-2 days in office on average " Hours Per Week: M-F " Shift Time: 8:00AM - 5:00PM PST
Share this job