Database analyst/Programmer
Aditi Consulting · Chillicothe, IL · Yesterday
On-siteInformation Technology$41–$42/hrContract
Payrate: $41.00 - $42.00/hr. 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, and administer role-based access controls to keep users accountable and compliant.Serve as the Data/Product Owner for multiple analytics programs and datasets, collaborating continually with the team where data sets and end-users often overlap to ensure consistent architecture and user experience.Support the Analytics team's modernization initiative, migrating from a legacy SAS central platform to a modern reporting framework.Coordinate, test, and implement changes to Snowflake databases, correcting errors and modifying databases/DBMS as needed.Author, troubleshoot, and performance-tune SQL views and queries, and build and maintain data pipelines (ETL) and job orchestration, including cloud scheduling such as AWS Lambda.Build and improve data sets and reporting for owned programs, and support customer inquiries on available data, enhancements, and general support.Advise and support the data needs of Data Specialists / Scientists and report builders, and perform joint planning to avoid duplicative or conflicting outputs. Typical task breakdown:Review and process access requests for data and reportingBuild or improve data sets or reporting for responsible programsManage data architecture for other members of the teamSupport customer inquiries for support, available data to consume, and enhancements to existing toolsAssist team members with tasks to help balance workloads Education & Experience Required: Years of experience: 2-4 yearsDegree 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 ArchitectureStrong 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 ControlsDocumentation of architecture and Program specific flowsVersion Control Systems and Code Review processesBI tooling (Power BI and/or Tableau)SAS familiarityNon-Snowflake source integration (DB2, Oracle, Teradata, SQL Server, NAS, SharePoint)Snowflake cost and storage optimization (warehouse sizing, compute/storage tuning)GitHub Copilot / Agentic AI experienceLeanIX (architecture and dependency cataloging) Soft Skills:Strong verbal and written communicationCustomer-service and stakeholder orientationIndependent time management and self-directionCross-team collaboration and joint planningAttention to detailComfort with ambiguity during transition and modernizationOwnership mindsetDocumentation and knowledge-transfer disciplineMentoring 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