Information Technology Spec 4 - Data Extraction Analyst
About The Position
The Data Extraction Analyst is responsible for designing, developing, and maintaining efficient and reliable data extraction processes to support business intelligence, reporting, and analytics needs. This role ensures that data is retrieved, transformed, and made available in a structured and accessible manner for decision-making. The Data Extraction Analyst collaborates with stakeholders across the organization to understand data needs, optimize data workflows, and ensure compliance with data governance, security, and privacy policies. This position plays a key role in improving data quality, accessibility, and operational efficiency within the organization.
Requirements
- Five (5) years of hands-on experience in data extraction, ETL/ELT development, and database management utilizing tools such as Dataflows Gen2, Data Pipelines, Azure Data Factory, ODI, GoldenGate, SQL Developer Data Modeler, Snowpipe or similar in managing extractions and transformations across OneLake, enabling unified orchestration of data from multiple cloud and on-prem systems. A Bachelor's degree in computer science, data science, business intelligence or related field can substitute for one year of experience
- Advanced SQL (T-SQL, PL/SQL, Snowflake SQL) expertise, with hands-on experience tuning queries and optimizing warehouse performance across Microsoft Fabric, Oracle ADW, or Snowflake to achieve high-throughput, low-latency extractions and transformations.
- Hands-on experience in Python, PowerShell or Bash scripting to automate and optimize extraction workflows, integrate with CI/CD pipelines, and eliminate manual processing.
- Demonstrated ability to work cooperatively and collaboratively on large/complex system deployment projects in a team environment, including a strong understanding of distributed data architectures.
- Proven ability to project manage and deliver complex data integration and extraction projects end-to-end, aligning cross-platform technical work and providing clear status reporting to leadership.
Nice To Haves
- Working toward certification in Microsoft Fabric, Oracle Data Management, or Snowflake.
- Familiarity with DevOps practices and automation.
- Experience in higher education data environments.
- Understanding of machine learning models and how structured data supports advanced analytics.
Responsibilities
- Designing, developing, and maintaining efficient and reliable data extraction processes to support business intelligence, reporting, and analytics needs.
- Ensuring that data is retrieved, transformed, and made available in a structured and accessible manner for decision-making.
- Collaborating with stakeholders across the organization to understand data needs
- Optimizing data workflows
- Ensuring compliance with data governance, security, and privacy policies.
- Improving data quality, accessibility, and operational efficiency within the organization.
Benefits
- 11 paid Holidays
- Vacation Time
- Sick Time
- six weeks of Paid Parental Leave
- low cost medical and dental insurance with low deductibles ($250 - $1500)
- a Pension Plan
- 457(b) and 403(b) retirement plans and other retirement investment options
- pre-tax medical and dental expense (with roll-over option) and dependent care accounts
- employer paid life insurance
- short and long term disability
- professional development
- a tuition waiver program for employees and their dependents
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
Industry
Ambulatory Health Care Services
Number of Employees
5,001-10,000 employees
