Jobs
>
Woodland

    Data/BI Architect in Woodland, CA - Elegant Enterprise- Wide Solutions Inc

    Default job background
    Description

    Job Description

    Job Description System Software Specialist (data & analytics focus) to be responsible for managing and optimizing our Data Lake/Warehouse, Business Intelligence, reports, and data analytics systems.

    The ideal consultant will have a strong background in Data Lake/Warehousing technologies, Business Intelligence tools, and data analytics, with expertise in Amazon Data Lake, Infor Birst, Microsoft Power BI, Microsoft SQL and Oracle Database Systems.

    Primary responsibilities fall within four broad areas at differing levels of individual responsibility.

    Data Architecture:
    Knowledge of building data orchestration and pipelines.
    Understanding of metadata management, data modeling & design, data integration, data lineage, data catalog and related tools.
    Design, develop, and maintain the Data Lake/Warehouse infrastructure, ensuring data integrity and performance optimization.
    Implement data modeling techniques and data integration processes to support efficient data extraction, transformation, and loading (ETL) operations.
    Collaborate with stakeholders to define data requirements and ensure data quality and consistency.
    Monitor and troubleshoot Data Lake/Warehouse performance issues, implementing necessary optimizations.


    Business Intelligence (BI) Development:

    Develop and maintain interactive reports, dashboards, and data visualizations using Microsoft Power BI, Infor Birst or other BI tools.

    Ability to understand the data needs of data users and quickly translate complex technical concepts into simplified business terms.

    Ability to transform complex data into easy-to-understand visual insights that are aligned to business objectives.
    Implement data cubes, data mining, and advanced analytics techniques to support decision-making processes.
    Collaborate with business users to understand their analytical needs and provide training and support on BI tools.


    Data Analytics:
    Perform data analysis, data mining, and statistical modeling to identify trends, patterns, and correlations.
    Proficiency in SQL query language and able to use many query tools
    Utilize data visualization techniques to communicate analytical findings and insights effectively.
    Identify opportunities for process improvements and data-driven decision-making.
    Develop predictive models and implement machine learning algorithms to support forecasting and predictive analytics.


    Report Generation:
    Design and generate reports based on business requirements using various reporting tools.
    Extract and manipulate data from multiple sources to generate accurate and meaningful reports.
    Automate report generation processes and ensure timely delivery of reports to stakeholders.
    Perform data analysis on reports to identify trends, patterns, and opportunities for improvement.

    The consultant will be required to work and collaborate with senior ITSD development staff and staff throughout the County Organization, create and maintain documentation related to enhancements, scripts, configurations, reports, and other changes to the systems.

    Consultant may be required to train IT and other county staff in use and maintenance of the systems.
    The consultant will work under the direction of the development IT Manager.

    Possess a deep understanding of Amazon Data Lake, Infor Birst, Microsoft Power BI, Microsoft SQL, and Oracle Database Systems to effectively leverage these technologies.

    Stay up to date with the latest trends and advancements in Data Lake/Warehouse, Business Intelligence, and data analytics fields.

    Provide technical guidance and expertise to the team and other stakeholders.
    4+ years of experience configuring, installing, upgrading, maintaining, diagnosing, analyzing, and resolving problems relating to network software systems.
    Detail-oriented & excellent communication skills.
    Ability to manage one's time efficiently & ability to work independently and with a team.

  • WinWire Technologies

    Data and BI Architect

    2 weeks ago


    WinWire Technologies Sacramento, United States

    Primary Skills (Must have) · Have hands-on experience and worked on at least 4 projects (a project should be minimum 3 months) using below tech, · SQL programming · Data lake storage · ADF and Databricks(Python/Scala) · Have worked on atleast 2 projects (project minimum 3 months) ...


  • California Employment Development Department (EDD) Sacramento, United States

    **Job Description and Duties** · **THIS POSITION MAY BE ELIGIBLE FOR A HYBRID WORK SCHEDULE. THE AMOUNT OF TELEWORK IS AT THE DISCRETION OF THE DEPARTMENT AND IS SUBJECT TO CHANGE AS BUSINESS NEEDS ARISE.** · Are you looking for a fast-paced and challenging position that will pro ...

  • West Advanced Technologies

    BI Architect

    2 weeks ago


    West Advanced Technologies West Sacramento, United States

    BI Architect · West Sacramento, CA · 36+ months · Mandatory Qualifications: · At least 10 years of hands-on experience with full life cycle of Data Warehouse technical design and development including logical and physical data modeling, mapping data elements from various ...


  • DiLytics Inc West Sacramento, United States

    DiLytics offers best-in-class team and cutting-edge analytics expertise with industry-leading data analytics tools to help you capture, organize and analyze your enterprise data for accurate, faster and more informed decision making. · DiLytics is looking for **Data Governance Ar ...

  • CalSTRS

    Data Architect

    3 days ago


    CalSTRS Sacramento, United States

    Job Posting: Data Architect · State Teachers' Retirement System · JC · Data Architect · INFORMATION TECHNOLOGY SPECIALIST II · $8, $10,893.00 per Month · **Final Filing Date:** **5/31/2024** · **Job Description and Duties** · **The CalSTRS Technology Services Branch is se ...

  • Speridian Technologies

    Data Architect

    3 weeks ago


    Speridian Technologies Sacramento, United States

    Speridian Technology is recruiting for a Data Architect for our State of CA client. This person will be part of a state of the art, extremely vast, IT modernization project with a variety of cross-functional teams. · This role is remote; however, teams may gather in California s ...

  • Speridian Technologies

    Data Architect

    3 weeks ago


    Speridian Technologies Sacramento, United States

    Speridian Technology is recruiting for a Data Architect for our State of CA client. This person will be part of a state of the art, extremelyvast, IT modernizationproject with a variety of cross-functional teams. · This role is remote;however,teams may gather in California sever ...

  • Public Consulting Group

    Data Architect

    4 days ago


    Public Consulting Group Sacramento, United States

    Overview · About Public Consulting Group · Public Consulting Group LLC (PCG) is a leading public sector solutions implementation and operations improvement firm that partners with health, education, and human services agencies to improve lives. Founded in 1986, PCG employs appr ...

  • Speridian Technologies

    Data Architect

    2 weeks ago


    Speridian Technologies Sacramento, United States

    Job Description · Job DescriptionSperidian Technology is recruiting for a Data Architect for our State of CA client. This person will be part of a state of the art, extremely vast, IT modernization project with a variety of cross-functional teams. · This role is remote; however, ...

  • Public Consulting Group

    Data Architect

    5 days ago


    Public Consulting Group Sacramento, United States

    Overview · About Public Consulting Group · Public Consulting Group LLC (PCG) is a leading public sector solutions implementation and operations improvement firm that partners with health, education, and human services agencies to improve lives. Founded in 1986, PCG employs appr ...


  • Elegant Enterprise Wide Solutions, Inc Woodland, United States

    Primary responsibilities fall within four broad areas at differing levels of individual responsibility. · - Data Architecture: · - Knowledge of building data orchestration and pipelines. · - Understanding of metadata management, data modeling & design, data integration, data line ...


  • Elegant Enterprise Wide Solutions, Inc Woodland, United States

    The Innovation and Technology Services Department is seeking a System Software Specialist (data & analytics focus) to be responsible for managing and optimizing our Data Lake/Warehouse, Business Intelligence, reports, and data analytics systems. · - Primary responsibilities fall ...


  • Elegant Enterprise Wide Solutions, Inc Woodland, United States

    Primary responsibilities fall within four broad areas at differing levels of individual responsibility. · - Data Architecture: · - Knowledge of building data orchestration and pipelines. · - Understanding of metadata management, data modeling & design, data integration, data line ...


  • Elegant Enterprise Wide Solutions, Inc Woodland, United States

    Primary responsibilities fall within four broad areas at differing levels of individual responsibility. · - Data Architecture: · - Knowledge of building data orchestration and pipelines. · - Understanding of metadata management, data modeling & design, data integration, data line ...


  • Elegant Enterprise Wide Solutions, Inc Woodland, United States

    The Innovation and Technology Services Department is seeking a System Software Specialist (data & analytics focus) to be responsible for managing and optimizing our Data Lake/Warehouse, Business Intelligence, reports, and data analytics systems. · - Primary responsibilities fall ...


  • AgreeYa Solutions Sacramento, United States

    Role: Data Warehouse Architect · Location Sacramento, CA Duration: Long-term · Project Description: · Client hosts a centralized Data Warehouse on the Snowflake Data Cloud to populate the Strategic Plan Dashboard. The Data Warehouse will continue to expand to house data across a ...

  • TechNix LLC

    Senior Data Architect

    3 weeks ago


    TechNix LLC Sacramento, United States

    Job Description · Job Description · Position: Senior Data Architect · Duration: 36 Months · Location: Sacramento, California (Onsite from Day 1) · Demonstrates experience with the database(s) design of all the components and has an enterprise view and ensures each component/mo ...


  • Gainwell Technologies - HMS Holdings Corporation Roseville, United States

    As a ?Data Solutions Architect (Roseville CA) at Gainwell, you can contribute your skills as we harness the power of technology to help our clients improve the health and well-being of the members they serve a communitys most vulnerable. Connect y Solutions Architect, Solutions, ...

  • NovaTech Solutions

    Tax Consultant

    2 weeks ago


    NovaTech Solutions Woodland, United States

    WHO WE ARE · AC CHRISTES & PARTNER GmbH is an internationally active auditing and tax consulting company based in Hamburg, Munich, and Düsseldorf. We have been specializing in advising medium-sized corporate transactions for over 30 years. Our clients include Private Equity funds ...


  • WinWire Technologies Sacramento, United States

    Data & Analytics – Sr. Consultant / Technical Architect · Data & Analytics – Sr. Consultant / Technical Architect · Overall industry experience: · 14+ Years · The candidate is expected to be a Sr. consultant / Technical Architect who can work with customers and teams (local or ...