Database Administrator (Snowflake, SQL, Python)- 721

DSM-H Consulting; Peoria (IL); On-site; USD 70,000 - 100,000; Full time

Job summary

DSM-H Consulting is seeking a Database Administrator to support a small analytics team. You will maintain data architecture, implement governance, and manage database objects while documenting the architecture and program flows.

You will own end-to-end user access management, serve as Data/Product Owner for multiple analytics programs, and help modernize by migrating from SAS to a modern reporting framework.

Qualifications

• 2–4 years of experience in a DBA/analytical role.
• Degree in computer programming or related field required; Bachelor’s preferred.

Responsibilities

• Maintain data architecture for the analytics team and other members.
• Own end-to-end user access management and RBAC to ensure compliance.
• Serve as Data/Product Owner for multiple analytics programs and datasets.
• Support modernization by migrating from legacy SAS to a modern reporting framework.
• Coordinate Snowflake changes, fix issues, and adjust DBMS as needed.
• Author, optimize, and troubleshoot SQL views/queries and ETL pipelines.
• Build and maintain data sets and reporting for owned programs; assist user inquiries.
• Advise data needs of Data Specialists/Scientists and coordinate cross-team planning.

Skills

Snowflake DBA

Data governance

SQL/ETL development

Education

Associate's degree in computer programming or relevant field

Bachelor's degree preferred

Tools

Power BI

Tableau

LeanIX

GitHub Copilot

Job description

- 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 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

- Assist team members with tasks to help balance workloads

Interaction with team

- Advise and support data needs for the rest of the team of Data Specialists / Scientists and report builders

- Perform joint planning to avoid duplication of efforts or conflicting outputs

- Assist the management of the footprint of technology (Snowflake, SAS, Oracle, Teradata, SQL Server, Power BI, Tableau)

- Frequent and detailed communication is needed on a daily basis

Team Structure

- Team of 6

Work environment

In office collaboration

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.

- Do you accept internships as job experience: if skills can be showcased, yes

- Are there past or additional job titles or roles that would provide comparable background to this role:

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

(Required)

· 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)

- 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

- LeanIX (architecture and dependency cataloging)

Soft Skills

(Required)

- Customer-service and stakeholder orientation

- Independent time management and self-direction

- Cross-team collaboration and joint planning

- Comfort with ambiguity during transition and modernization

- Ownership mindset

- Documentation and knowledge-transfer discipline