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

-