What are the responsibilities and job description for the Database Administrator (Snowflake, SQL, Python)- 721 position at DSM-H Consulting?
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, SharePoint)
- 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
-