Senior Data Warehouse / BI Analyst
Hybrid in Lansing, MI, US • Posted 8 hours ago • Updated 8 hours agoContract Corp To Corp
Contract Independent
Contract W2
Hybrid
Depends on Experience
tCognition, Inc
Fitment
Dice Job Match Score™
🤯 Applying directly to the forehead...
Job Details
Skills
- Agile
- Analytical Skill
- Business Intelligence
- Data Warehouse
- Disaster Recovery
- PMM
- Data Marts
- Dashboard
- Snow Flake Schema
- SQL
- Test Plans
- Regulatory Compliance
- Change Management
- Extract
- Transform
- Load
- Public Sector
- Production Support
- Teradata
- Documentation
- End-user Training
- IT Management
- Customer Facing
- Communication
- Auditing
Summary
Job Description Senior Data Warehouse / BI Analyst (Teradata)
Client: State of Michigan
Location: Hybrid (Lansing, MI)
Contract: 12 Months
Interview Type: F2F
Job Summary
The Senior Data Warehouse / BI Analyst is responsible for developing, maintaining, and enhancing enterprise data warehouse applications on the State of Michigan s Teradata Data Warehouse platform. This role supports Michigan DHHS initiatives by delivering ETL solutions, data marts, reports, dashboards, and analytical data products while coordinating with cross-functional data warehouse and agency teams.
Key Responsibilities
- Design, develop, and maintain Teradata-based data warehouse solutions including ETL processes and data marts
- Develop and support BI reports, dashboards, and analytical queries to meet business and agency needs
- Work cross-functionally across ETL and BI activities, supporting end-to-end data delivery
- Collaborate with data modelers, developers, architects, DBAs, and agency stakeholders on complex projects
- Review and enhance existing data warehouse standards, policies, and practices
- Gather, analyze, and document business requirements and translate them into technical solutions
- Support Child Welfare, Juvenile Justice, or related human services data environments
- Use SQL Assistant / Teradata Studio to develop, optimize, and troubleshoot SQL queries
- Provide production support, change management, and disaster recovery input for DW systems
- Assist with test planning, security validation, audit compliance, and documentation
- Serve as a technical lead, providing guidance and direction to development staff
- Communicate complex technical concepts clearly to business and technical audiences
Required Skills
- Strong experience developing Data Warehouse and BI solutions
- Hands-on ETL and data mart development
- Reporting and dashboard development experience
- Teradata SQL development using SQL Assistant / Teradata Studio
- Experience supporting Child Welfare, Juvenile Justice, or related human services systems
- Strong analytical, communication, and documentation skills
Preferred Skills
- Experience with Snowflake and/or Databricks
- Familiarity with State of Michigan PMM / SUITE / Agile methodology
- End-user training and client-facing experience
- Experience working in state or public-sector environments
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
- Dice Id: RTL124041
- Position Id: 8858739
- Posted 8 hours ago
Company Info
tCognition Inc. established in 2003, a Minority Based Entrepreneur(MBE) for MA, NY and GSA certified company with offices in Boston (Massachusetts) & Kolhapur (India) offers IT/Software Staffing, Consulting and Outsourcing Services for its customers.
tCognition, Inc is awarded GSA Schedule contract GS-35F-0495T administered by the US Federal Supply Service of the General Services Administration. As a GSA contractor under FSS Schedule 70, tCognition provides an array of Information Technology products and services, including equipment, software and professional services awarded under FCIS-JB-9800001B (Revision 20). Any agency of the U.S. Government may take advantage of Schedule 70 task orders to secure products and services in a variety of skill areas, including systems analysis, design, and installation; programming; and integrated logistics support.
tCognition, Inc is awarded GSA Schedule contract GS-35F-0495T administered by the US Federal Supply Service of the General Services Administration. As a GSA contractor under FSS Schedule 70, tCognition provides an array of Information Technology products and services, including equipment, software and professional services awarded under FCIS-JB-9800001B (Revision 20). Any agency of the U.S. Government may take advantage of Schedule 70 task orders to secure products and services in a variety of skill areas, including systems analysis, design, and installation; programming; and integrated logistics support.
Create job alert
Never miss an opportunity! Create an alert based on the job you applied for.Similar Jobs
It looks like there aren't any Similar Jobs for this job yet.
Search all similar jobs