Jobs · Information Technology · Illinois

Database analyst/Programmer

Aditi Consulting · Chillicothe, IL · 1 mo ago
On-siteInformation Technology$41–$42/hrContract

Position’s Contributions to Work Group

The position fills the Database Administrator (DBA) role for a small analytics team, maintaining the intended data architecture (including for other team members), implementing data governance, creating and managing database objects, and documenting the architecture and program-specific flows.

Own End-to-End User Access Management

  • Triage access requests
  • Obtain approvals/denials
  • Communicate results
  • Grant access
  • Administer role-based access controls

Data/Product Owner for Multiple Analytics Programs and Datasets

  • Collaborate continually with the team
  • Ensure consistent architecture and user experience

Support Modernization Initiative

  • Migrate from a legacy SAS central platform to a modern reporting framework

Coordinate, Test, and Implement Changes to Snowflake Databases

  • Correct errors
  • Modify databases/DBMS as needed

Build and Maintain Data Pipelines (ETL)

  • Create and maintain data pipelines
  • Build and improve data sets and reporting for owned programs
  • Support customer inquiries on available data, enhancements, and general support

Advise and Support Data Needs

  • Advise and support the data needs of Data Specialists / Scientists and report builders
  • Perform joint planning to avoid duplicative or conflicting outputs

Typical Task Breakdown

  • Review and process access requests for data and reporting
  • Build or improve data sets or reporting for responsible programs
  • Manage data architecture for other members of the team
  • Support customer inquiries for support, available data to consume, and enhancements to existing tools
  • Aid team members with tasks to help balance workloads

Education & Experience Required

  • Years of experience: 2-4 years
  • Degree requirement: Associate's degree in computer programming or relevant field required. Bachelor's degree preferred.

Top 3 Skills

  • Snowflake Database Administration (implementing, debugging/troubleshooting/tracing, issue resolution)
  • Data Governance and Architecture
  • Strong SQL and query engineering / Data pipeline / ETL development (view/query authoring, troubleshooting, performance tuning)

Additional Technical Skills

  • Strong SQL (query/view authoring, troubleshooting, and performance tracing)
  • Python (scripting and automation)
  • Data pipeline / ETL and job orchestration (including cloud scheduling such as AWS Lambda)

Role-Based Access Controls

Documentation of architecture and Program specific flows

Version Control Systems and Code Review Processes

BI Tooling (Power BI and/or Tableau)

SAS Familiarity

Non-Snowflake Source Integration (DB2, Oracle, Teradata, SQL Server, NAS, SharePoint)

Snowflake Cost and Storage Optimization (warehouse sizing, compute/storage tuning)

GitHub Copilot / Agentic AI Experience

Lever (architecture and dependency cataloging)

Soft Skills

  • Strong verbal and written communication
  • Customer-service and stakeholder orientation
  • Independent time management and self-direction
  • Cross-team collaboration and joint planning
  • Attention to detail
  • Comfort with ambiguity during transition and modernization
  • Ownership mindset
  • Documentation and knowledge-transfer discipline
  • Mentoring and peer-support skills

Pay Transparency

The typical base pay for this role across the U.S. is: $41.00 - $42.00 /hr.

Non-exempt positions are eligible for overtime at a rate of 1.5 times the base hourly rate for all hours worked in excess of 40 in a work week, or as required by state or local law.

Final offer amounts, within the base pay set forth above, are determined by factors including your relevant skills, education and experience.

Full-time employees are eligible to select from different benefits packages. Packages may include medical, dental, and vision benefits, health savings accounts with qualified medical plan enrollment, 10 paid days off, 3 days paid bereavement leave, 401(k) plan participation with employer match, life and disability insurance, commuter benefits, dependent care flexible spending account, accident insurance, critical illness insurance, hospital indemnity insurance, accommodations and reimbursement for work travel, and discretionary performance or recognition bonus.

Sick leave and mobile phone reimbursement provided based on state or local law.

Consent to Communication and Use of AI Technology

By submitting your application for this position and providing your email address(es) and/or phone number(s), you consent to receive text (SMS), email, and/or voice communication whether automated (including auto telephone dialing systems or automatic text messaging systems), pre-recorded, AI-assisted, or individually initiated from Aditi Consulting, our agents, representatives, or affiliates at the phone number and/or email address you have provided. These communications may include information about potential opportunities and information. Message and data rates may apply. Message frequency may vary. You represent and warrant that the email address(es) and/or telephone number(s) you provided to us belong to you and that you are permitted to receive calls, text (SMS) messages, and/or emails at these contacts. You also acknowledge and agree to Aditi Consulting LLC’s use of AI technology during the sourcing process, including calls from an AI Voice Recruiter. AI is used solely to gather data and does not replace human-based decision-making in employment decisions. Calls may be recorded. Consent is not a condition of purchasing any property, goods, or services. You may revoke your consent at any time by replying “STOP” to :messages or by contacting privacy@aditiconsulting.com.

For Information About Our Collection, Use, and Disclosure of Applicant's Personal Information as Well as Applicants' Rights Over Their Personal Information

Please see our Privacy Policy #AditiConsulting #26-05298

Similar jobs

Database Analyst

Fix Network WorldFort Myers, FL· 2 mo ago
Information Technologyapply on ats.rippling.com

DATABASE ANALYST

Avesta CropScience Inc.Cary, NC· 2 mo ago
Information Technologyapply on sucittastealth.bamboohr.com