• The ideal candidate 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.

Job Type: Full-time

Pay: $59,836.92 - $72,061.66 per year

Schedule:

• Day shift

Experience:

• Help desk: 1 year (Preferred)
• Windows: 1 year (Preferred)

Ability to Commute:

• Woodland, CA (Required)

Ability to Relocate:

• Woodland, CA: Relocate before starting work (Required)

Work Location: In person