Database Administrator (Snowflake, SQL, Python

• 721 at DSM-H Consulting Database Administrator (Snowflake, SQL, Python
• 721 at DSM-H Consulting in Creve Coeur, Illinois Posted in 3 days ago.

Type:

full-time

Job Description:

Open for Chillicothe, IL as well 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 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 (Desired)
• BI tooling (Power BI and/or Tableau)
• SAS familiarity
• Non-Snowflake source integration (DB2, Oracle, Teradata, SQL Server, NAS, Point)
• Snowflake cost and storage optimization (warehouse sizing, compute/storage tuning)
• GitHub Copilot / Agentic AI experience
• LeanIX (architecture and dependency cataloging) Soft Skills (Required)
• 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 (Desired)
• Comfort with ambiguity during transition and modernization
• Ownership mindset
• Documentation and knowledge-transfer discipline
• Mentoring and peer-support skills