Data Engineer; Business Analyst IV

Job Announcement

Join our innovation team as a data engineer with the Department of Information Technology! Under the leadership of Chief Director of Innovation, you'll drive county-wide data-informed decision making, boost organizational transparency, and enhance operational efficiency by building robust data pipelines, managing advanced database architectures, ensuring top-tier data quality, governance, and security, and partnering closely with analytics/AI teams to deliver scalable, reliable data solutions.

• Designs, builds, and maintains ETL (Extract, Transform, Load) pipelines using orchestration tools (e.g., Apache Airflow, Azure Data Factory) and big data frameworks (e.g., Spark, Hadoop) to transport raw data from multiple sources into centralized repositories like data warehouses and data lakes.
• Manages database and data architecture by designing, implementing, and optimizing storage solutions (e.g., PostgreSQL, SQL Server, MongoDB, Cassandra, AWS S3, Google Big Query), including schemas, partitioning, indexing, and data modeling to balance performance, scalability, and cost for transactional and analytical workloads.
• Ensures data quality, governance, and security through validation rules, anomaly monitoring, metadata/lineage management, compliance frameworks (e.g., GDPR, HIPAA), encryption, access controls, and auditing in partnership with security teams.
• Collaborates with business analysts, data scientists, and developers to provide optimized datasets, improve query performance, integrate APIs, and support data projects for decision-making and innovation.
• Builds and manages Snowflake data environments, including initial environment setup, warehouse configuration, role-based access controls, data ingestion pipelines, and performance optimization to support scalable, secure, and cost-efficient analytics.
• Manages cross-functional teams supporting data initiatives.
• Performs other duties as required to support business intelligence and data efforts.

NOTE:
This position may be filled as an underfill at the Business Analyst III or Business Analyst II level. Underfill requirements are noted below in the Employment Standards section.

Any combination of education, experience, and training equivalent to the following:
Bachelor's degree in computer information systems, business administration, or related field; plus five years of experience in information systems and process redesign, managing and implementing all phases of the systems development life cycle, including at least one year of supervisory experience.

This position may be underfilled at the Business Analyst III (Grade S29; $87,024.91 - $ annually) or Business Analyst II (Grade S26; $75,474.26 - $ annually) level.

• Business Analyst III Minimum Qualifications are:
  Any combination of education, experience, and training equivalent to the following:
  Bachelor's degree in business, computer science or a field related to the department where the IT services are being used: plus four years of experience analyzing business processes and/or developing/maintaining the main business system, technical platform or a related system.

NOTE:
Candidates appointed to these positions at the Business Analyst III grade level will be eligible for a non-competitive promotion to the Business Analyst IV grade level upon successful completion of the underfill agreement. Underfill candidates must be able to meet the minimum qualifications of the Business Analyst IV within 1 year of the job announcement's closing date.

• Business Analyst II Minimum Qualifications are:
  Any combination of education, experience, and training equivalent to the following:
  Bachelor's degree in business, computer science or a field related to the department where the information technology services are being used; plus two years of experience analyzing business processes and/or developing/maintaining the main business system, technical platform or a related system.

NOTE:
Candidates appointed to these positions at the Business Analyst II grade level will be eligible for a non-competitive promotion to the Business Analyst III grade level upon successful completion of the underfill agreement. Underfill candidates must be able to meet the minimum qualifications of the Business Analyst III within 2 years of the job announcement's closing date.

The appointee to this position will be required to complete a criminal background check to the satisfaction of the employer.

• Experience designing/maintaining ETL pipelines utilizing tools such as Apache Airflow or Azure Data factory.
• Strong experience with big data frameworks (e.g., Spark, Hadoop), and cloud storage (e.g., AWS S3, Google Big Query).
• Experience integrating external data sources via APIs or streaming frameworks into centralized repositories.
• Experience building or optimizing data lakes or data warehouses, including scheme design and…