STATEMENT OF WORK

SECTION 1.0 PROJECT OVERVIEW

has been awarded a grant which includes the Implementation of Common Education Data Standards (CEDS) databases and an upgrade of the CDE infrastructure.

A CDE employee will be partnering with the selected individual to work on the SLDS (Statewide Longitudinal Data System) project and on the on-going daily maintenance work.

This statement of work is to engage a contractor for this partnership. Included in the daily work but not limited to, is maintaining the existing Oracle Data Warehouse environment and ETL development.

The contractor will need experience in Informatica and SQL. This involves using Informatica and SQL to load tables and gene files for federal reporting.

In addition, this individual may be requested to provide recommendations, documentation, and knowledge transfer to the CDE staff.

With this partnership the need for knowledge transfer should happen in the normal course of work between the DW team and the contractor.

GENERAL REQUIREMENTS

1.1 The Department’s Project Manager for this project is Kevin Smith (Business Intelligence and Data Warehouse Team Supervisor).

This contractor will report to Kevin Smith.

1.2 Contractor shall work closely and collaboratively with the Department’s Project Manager throughout the duration of the Purchase Order to discuss suggestions or issues and incorpo guidance from the Department while performing the work described within this Statement of Work.

1.3 The Contractor shall alert the Department’s Project Manager, when issues or potential risks are encountered that will affect the project.

Prior to the Covid crisis, nearly all staff, employees and contractors worked on premises at the CDE office located at 201 E.

Colfax Ave, Denver, CO 80203. During the crisis, most staff, employees, and contractors have worked from remote locations.

Policies have not been fully formulated for how we will work in the future. Once they are completed, it is expected to be dependent on the roles and the need for each role to be in the office.

For most roles, it is likely to be a blend of office and remote work.

For this role, Database Programmer, applicants can expect to work remotely.

NOTE : Contractor shall provide its their own computer hardware and software necessary to perform the Work at CDE’s facilities.

If working at the CDE office, CDE will provide the contractor with office space, phone, and internet access at CDE’s Colfax office subject to all applicable health and safety guidelines and requirements.

While working remotely at locations other than CDE’s office, CDE will provide the contractor with virtual access to the data and systems necessary for completion of the Work.

1.4 The Contractor shall provide documentation to the Project Manager. This documentation must provide details on the work provided and at a level a Department employee can use the information to support the work at the end of the contract.

1.5 The Contractor shall submit detailed status reports or participate in weekly status meetings as required by the Department during the engagement.

1.6 The Contractor shall attend required meetings with the required project stakeholders as directed by the Department. These meetings will be scheduled by a Department employee.

All questions and communication should go through the Project Manager, Kevin Smith. If Kevin is not available, he will designate a Department employee for the communication.

1.7 Contractor shall retain all work papers gene d for reference through the duration of the project and project acceptance.

1.8 Contractor shall respond to all telephone calls, voicemail, and e-mail inquiries from the Department within one business day.

SECTION 2.0 CONFIDENTIALITY AND PROTECTION OF PERSONALLY IDENTIFIABLE INFORMATION

2.1. The Student Data Transparency and Security Act (C.R.S. 22-16-101, et seq.) governing the privacy of Personally Identifiable Information requires a confidentiality contract between CDE and Contractor.

2.2. Attached hereto and incorpo d herein by reference and agreed to by the parties is a Confidentiality and Protection of Personally Identifiable Information Agreement ( Confidentiality Agreement ).

Terms of the Confidentiality Agreement shall be considered binding upon the execution of the Purchase Order and shall remain in effect during the term of the Purchase Order including any extensions.

SECTION 3.0 Balance SLDS Work With DAILY Maintenance of our existing structure

3.1. With the guidance of the data warehouse manager and in partnership with a DW employee, the contractor shall

3.1.1. Review internal CDE documentation and provide maintenance and support for the existing CDE Informatica and SQL processes.

3.1.2. Review status on the SLDS project and perform tasks as determined by the partnership. This may include, but is not limited to, mapping of data fields to the new environment and structures, migrating data, testing, and other duties as assigned in the MS Azure cloud environment using SQL and possibly Data Factory skills

3.2. Informatica Skills

Strong development skills : ability to develop very difficult or complicated transformation from scratch

Strong administrative skills including repository management and knowledge of best practices regarding Informatica

3.3. Strong oral and written communication skills working with both business users and technical staff

3.4. The contractor shall demonst their understanding of the overall project goals and the specific goals as pertains to the contractor’s assignment for this project to the satisfaction of the Project Manager.

3.5. The contractor be able to advise and provide guidance on the requested work.

3.6. The contractor shall develop, maintain, and support Extract Transform and Load processes which are written using Informatica and SQL.

3.7. The contractor shall use Informatica and SQL to load the CDE Data Warehouse tables and gene Ed Facts files for federal reporting.

3.8. The contractor shall thoroughly test and document each step taken and perform knowledge transfer to the CDE staff.

Required Skills : - ETL 4-6 years - Informatica 4-6 years - Oracle Data Warehouse 4-6 years - SQL 4-6 years

Basic Qualification :

Additional Skills :

Background Check : Yes

Drug Screen : Yes

Notes :

Selling points for candidate :

Project Verification Info :

Candidate must be your W2 Employee : Yes

Exclusive to Client : No

Face to face interview required : No

Candidate must be local : Yes

Candidate must be authorized to work without sponsorship : : No

Interview times set : : No

Type of project : Architecture / Design

Master Job Title : ETL Developer

Branch Code : Colorado Springs

Indotronix is an Equal Opportunity Employer

We are looking for a Sr. Data Scientist I with strong expertise in statistics / modeling, machine learning to join our diverse team of data scientists on the Auto Insurance Rating Analytics team.

This individual will play a key role in new product innovation, model development, generating actionable insights, and working closely with the Vertical and Product teams to design and implement new solutions that are cutting edge and support the insurance market.

General Profile :

• Experienced practitioner
• Works independently and possesses in-depth knowledge and experience
• Solves complex problems
• Contributes to process improvements
• Uses best practices and knowledge of internal or external business issues to improve products or services
• Acts as a resource for colleagues with less experience
• Supports existing models
• Python experience required
• Cloud experience preferred
• Develops, analyzes and models operational, economic, management, accounting and other organizational data to quantify the competitive performance of business segments, evaluate potential operational changes, and design new approaches and methodologies
• Analyzes organizational data to recommend solutions to new and complex problems, develops innovative strategies, quantifies the competitive performance of the organization's operations and / or markets;

models and evaluates the potential impact of changes

Applies and integrates statistical, mathematical, predictive modeling and business analysis skills to manage and manipulate complex high volume data from a variety of sources

Qualifications :

Bachelor’s degree in Mathematics, Statistics, Computer Science, Data Science, or other quantitative discipline (or equivalent years of experience);

Master’s / Ph.D. degree preferred.

• 3+ years demonstrated experience in data manipulation and various AI / ML methodologies, preferably in applications using credit data for insurance or financial services.
• Strong expertise in one or more of the following : R, Python, SQL, or equivalent analytic software.
• Experience manipulating and merging multiple large data sets in a distributed computing environment.
• Solid understanding of ML techniques including hypothesis testing, sample design, model development (linear and non-linear models), validation of machine learning models.
• Strong programming skills in Python and / or R, with extensive experience with their standard data manipulation and ML packages.

pandas, scikit-learn, NumPy, XGBoost, PyTorch in Python and rpart, party, caret in R) and / or Scala.

Strong ability as a self-starter to learn new technologies (Pyspark, ECL, Azure / AWS ML Services) and to share cross-functional knowledge across the teams nice to have.

LI-Remote

LI-CH1

Job Information

CSAA Insurance Group (CSAA IG), a AAA insurer, is one of the top personal lines property and casualty insurance groups in the U.

S. Our employees proudly live our core beliefs and fulfill our enduring purpose to help members prevent, prepare for and recover from life's uncertainties, and we're proud of the culture we create together.

As we commit to progress over perfection, we recognize that every day is an opportunity to be innovative and adaptable. At CSAA IG, we hire good people for a brighter tomorrow.

We are actively hiring for a Data Engineer Remote! Join us and support CSAA IG in achieving our goals.

Your Role :

The Data Engineer is responsible for development and delivery of software in support of business capabilities and the foundational needs of the overall solution.

They provide technical expertise and mastery to deliver high-quality software and employs software engineering methods in the delivery of the same.

Responsible for achieving high degrees of automation using well established DevOps and Agile practices working with Product Managers, business stakeholders and other technology practitioners (Software Engineers, QA Engineers, Technical Analysts, as well as Solution Architects).

Your Work :

Works with others on the development team to develop, test and maintain features within digital applications.

Learns and follows all established technical and quality processes throughout the software development lifecycle.

Participates in team design, scoping and prioritization sessions, and provides regular demonstrations of completed work.

Serves as a software engineering resource on the Digital Engineering Team, while building CSAA’s next generation of customer-facing web and mobile applications.

Works with others on the development team to develop, test and maintain features within digital applications.

Learns and follows all established technical and quality processes throughout the software development lifecycle.

Participates in team design, scoping and prioritization sessions, and provides regular demonstrations of completed work.

Write secure, stable, testable, maintainable code with minimal defects, in a fast-paced, Agile environment.

Use technology to implement solutions to well defined problems, deliver it on schedule, applying appropriate technologies and current software engineering best practices.

Take a defined design and turn it into code.

Participate in team design, scoping and prioritization discussions.

Deliver thoroughly well designed, thoroughly and fully test covered code.

Create and maintain optimal data pipeline architecture,

Assemble large, complex data sets that meet functional / non-functional business requirements.

Identify, design, and implement internal process improvements : automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.

Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL and AWS big data’ technologies.

Build analytics tools that utilize the data pipeline to provide actionable insights into customer acquisition, operational efficiency and other key business performance metrics.

Work with stakeholders including the Executive, Product, Data and Design teams to assist with data-related technical issues and support their data infrastructure needs.

Keep our data separated and secure across national boundaries through multiple data centers and AWS regions.

Create data tools for analytics and data scientist team members that assist them in building and optimizing our product into an innovative industry leader.

Work with data and analytics experts to strive for greater functionality in our data systems.

Develop Stored Procedures on Snowflake.

Demonstrates a desire to learn and expand technical abilities.

What would make us excited about you?

Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases.

Experience building and optimizing big data’ data pipelines, architectures, and data sets.

Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement.

Strong analytic skills related to working with unstructured datasets.

Build processes supporting data transformation, data structures, metadata, dependency, and workload management.

A successful history of manipulating, processing and extracting value from large, disconnected datasets.

Working knowledge of message queuing, stream processing, and highly scalable big data’ data stores.

Experience with Snowflake, Hadoop, Spark, Kafka, etc.

Experience with relational SQL and NoSQL databases, including Postgres and Cassandra.

Experience with data pipeline and workflow management tools : Azkaban, Luigi, Airflow, etc.

Experience with AWS cloud services : EC2, EMR, RDS, Redshift

Experience with stream-processing systems : Streamsets, Storm, Spark-Streaming, etc.

Experience with object-oriented / object function scripting languages : Python, Java, C++, Scala, etc.

A Bachelor’s Degree in Computer Science or a related field is highly desired.

Actively shapes our company culture (e.g., participating in employee resource groups, volunteering, etc.)

Lives into cultural norms (e.g., willing to have cameras when it matters : helping onboard new team members, building relationships, etc.)

Travels as needed for role, including divisional / team meetings and other in-person meetings

Fulfills business needs, which may include investing extra time, helping other teams, etc.

CSAA IG Careers

At CSAA IG, we’re proudly devoted to protecting our customers, our employees, our communities, and the world at large. We are on a climate journey to continue to do better for our people, our business, and our planet.

Taking bold action and leading by example. We are citizens for a changing world, and we continually change to meet it.

Join us if you

BELIEVE in a mission focused on building a community of service, rooted in inclusion, and belonging.

COMMIT to being there for our customers and employees.

CREATE a sense of purpose that serves the greater good through innovation.

Recognition : We offer a total compensation package, performance bonus, 401(k) with a company match, and so much more!

Ankura is a team of excellence founded on innovation and growth.

Practice Overview

Ankura’s Data Privacy Practice offers a full-service suite of data privacy solutions for clients, regardless of industry or size.

Our experts assess data privacy risk and readiness relative to existing and emerging privacy regulations and help organizations build and mature their privacy programs.

Role Overview

Our Privacy practice is a rapidly growing part of the Data & Technology segment of our business. The Senior Director will help our clients address their data privacy challenges, including conducting privacy risk assessments, creating policies and procedures, building data inventories, reviewing, and interpreting regulatory changes, developing consumer response processes, implementing technology, and assisting organizations through privacy related regulatory investigations.

This is a remote based position.

Responsibilities :

Lead day-to-day activities of engagements including interaction with other team members, subject matter experts, external counsel, and client contacts.

Manage all facets of client engagements, including project planning, work stream supervision, budgeting, and billing.

Create project status summaries, reports, metrics, written analyses, assessments, and other presentations of work performed.

Create and update policies and procedures to support compliance with various regulations.

Actively participate in and lead internal and external team meetings including client assessments, presentations, and status meetings.

Manage time and tasks to meet internal and external deadlines.

Develop privacy program strategy for client engagements, using a privacy framework and supported by a working knowledge of applicable privacy regulations and requirements.

Mentor practice members to enable their professional development and continued growth.

Develop standardized metrics, methodologies, and other work product to be delivered by client project teams.

• Oversee delivery of engagements related to Privacy Technology implementations, integrations, and configurations; privacy by design;
• Software / Solution Development Lifecycle (SDLC) integration; privacy source code analysis; website and application compliance;

and Privacy Technology training and adoption.

Develop and deploy methodologies to advise clients on integrating data protection by design principles to the SDLC, including requirements elicitation, design, implementation, testing, deployment, and ongoing administration and maintenance.

Develop and deploy methodologies to advise clients on applying consent models to cookies, pixels, beacons, and other tracking technologies for websites and mobile applications.

Develop and deploy website scanning strategies and technologies; recommend and implement technical measures to support compliance with consent and preference management obligations.

Develop integration strategies between privacy technologies and privacy-adjacent solutions such as those used by Human Resources, Enterprise Architecture, Analytics, Marketing, and other business functions.

Develop and deploy anonymization, pseudonymization, and encryption capabilities to support privacy obligations.

Conduct / lead client interviews, ensure that the team develops appropriate pre-meeting materials and conducts background research, and mentor practice members in client environments.

Build relationships with other Ankura professionals and participates in industry events where subject matter expertise is requested.

Interact with Ankura team members in the US and within global business groups to ensure client needs are met.

Ensure clients are provided high-quality services from all levels of the team and provide an appropriate level of oversight and review of client reports and deliverables.

Maintain a professional image within the company and project the same to those outside of the company.

Qualifications

Bachelor’s Degree with a solid academic performance

7+ years of experience managing large, complex data privacy or compliance engagements

7+ years of experience in a consulting environment preferred

Knowledge and experience developing and managing key privacy deliverables such as : Data inventory registers, Privacy impact assessments, Privacy training, Cookies solution

Deep knowledge of privacy regulations and frameworks (, GDPR, CCPA, HIPAA) and their practical implementation.

Proven track record of successfully leading, managing, and developing a team of privacy consultants or professionals.

Excellent communication and interpersonal skills, with the ability to explain complex privacy concepts to non-technical stakeholders.

Project management experience including understanding of project life cycles (PMP or other project management certifications)

Strong analytical and problem-solving abilities to identify privacy risks and develop practical solutions.

Certified Information Privacy Professional (CIPP) certification (preferred)

Demonstrated thought leadership through publications, presentations, or contributions to industry forums.

Willingness and flexibility to travel as required

If you are passionate about privacy, possess exceptional leadership skills, and have a track record of delivering high-quality privacy consulting services, we would love to hear from you.

Join our team and make a significant impact on privacy practices across industries.

For individuals assigned and / or hired to work in California, Colorado, or New York, Ankura is required to include a reasonable estimate of the compensation range for this role.

This compensation range is specific to the said markets and considers a broad range of factors including but not limited to skill sets, experience and training, licensure and certifications, and other business and organizational needs.

The disclosed range estimate has not been adjusted for the applicable geographic differential associated with the location at which the position may be filled.

The range does not include additional benefits outside of salary. At Ankura, it is not typical for an individual to be hired at or near the top of the range for their role and compensation decisions are dependent on the facts and circumstances of each role.

A reasonable estimate of the current base pay range is between $110,000 to $240,000; this range is not a promise of a particular wage.

LI-Remote

LI-NT1

Job Description :

Integral Ad Science (IAS) is a global leader in digital media quality. IAS makes every impression count, ensuring that ads are viewable by real people, in safe and suitable environments, activating contextual targeting, and driving supply path optimization.

As a Staff Data Engineer you will design, implement, and maintain big data pipelines responsible for aggregating tens of billions of daily transactions.

You will be part of a growing team to develop and mature IAS’ capability in video ad verification, analytics and anti ad fraud software products.

What you’ll get to do :

Architect, design, code and maintain components for aggregating tens of billions of daily transactions

Work on Big Data technologies such as Hadoop, MapReduce, Kafka, and / or Spark in columnar databases on AWS

Contribute to the entire software lifecycle including hands-on development, code reviews, testing, deployment, and documentation for streaming & batch ETL and RESTful APIs

Provide leadership, work collaboratively, and be a mentor in an awesome team

You should apply if you have most of this :

Bachelors or Masters in Computer Engineering, Computer Science, Electrical Engineering or related field

8+ years of recent hands-on experience with an object oriented language (Java, Scala, Python)

8+ years of experience designing and building data pipelines and data-intensive applications

Experience using Big Data frameworks (e.g., Hadoop, Spark) , databases (e.g., RedShift, Snowflake) for complex data assembly and transformation

Strong knowledge of collections, multi-threading, JVM memory model, etc.

In-depth understanding of algorithms, performance, scalability, and reliability in a Big Data setting

Solid understanding of OLTP and OLAP systems, database fundamentals

Solid knowledge of SQL

Experience in full software development, Agile, and CI / CD

Experience building production level systems in a cloud environment (AWS, Azure or GCP)

What puts you over the top :

Orchestrating data pipelines using tools such as Airflow

Familiarity with messaging frameworks like Kafka or RabbitMQ

Experience with Spark streaming or Flink

New York Applicants : The salary range for this position is $154,000 - $231,000, actual pay may vary based on experience or geographic location.

About Integral Ad Science

Integral Ad Science (IAS) is a global leader in digital media quality. IAS makes every impression count, ensuring that ads are viewable by real people, in safe and suitable environments, activating contextual targeting, and driving supply path optimization.

Our mission is to be the global benchmark for trust and transparency in digital media quality for the world’s leading brands, publishers, and platforms.

We do this through data-driven technologies with actionable real-time signals and insight. Founded in 2009 and headquartered in New York, IAS works with thousands of top advertisers and premium publishers worldwide.

For more information, visit or email us at .

Equal Opportunity Employer :

IAS is an equal opportunity employer, committed to our diversity and inclusiveness. We will consider all qualified applicants without regard to race, color, nationality, gender, gender identity or expression, sexual orientation, religion, disability or age.

We strongly encourage women, people of color, members of the LGBTQIA community, people with disabilities and veterans to apply.

California Applicant Pre-Collection Notice :

We collect personal information (PI) from you in connection with your application for employment or engagement with IAS, including the following categories of PI : identifiers, personal records, commercial information, professional or employment or engagement information, non-public education records, and inferences drawn from your PI.

We collect your PI for our purposes, including performing services and operations related to your potential employment or engagement.

For additional details or if you have questions, contact us at .

To learn more about us, please visit and

Attention agency / 3rd party recruiters : IAS does not accept any unsolicited resumes or candidate profiles. If you are interested in becoming an IAS recruiting partner, please send an email introducing your company to .

We will get back to you if there's interest in a partnership.

LI-Hybrid