Business Intelligence Data Warehouse Consultant

About Trilyon For over 16 years, Trilyon has been a leader in global workforce solutions, specializing in Cloud Technology, AI/ML, Software Development, Technical Writing, and Digital Transformation. We partner with top companies to deliver high-quality talent in engineering, IT, and emerging technologies. Job Title: Data Warehouse Business Analyst / Reporting Analyst (HYBRID) Interview-In Person Location-Lansing,Michigan,48933 Accepting local candidates within 2 hours of Lansing, MI ONLY Job Description The Data Warehouse Business Analyst / Reporting Analyst supports the Data Warehouse Team, which delivers critical data used in eligibility determinations, reporting, and program oversight for public assistance programs. This role serves as a key liaison between business stakeholders and technical teams, translating business needs into actionable data, reporting, and analytics solutions. The analyst leverages SQL-based tools to perform data analysis, create reports and dashboards, validate data quality, and ensure compliance with federal and state requirements. Key Responsibilities • Collaborate with business users, and technical teams to gather, analyze, and document business, reporting, and data requirements. • Translate business needs into detailed reporting, ETL, and analytics requirements to support eligibility determinations and program management. • Develop, execute, and maintain ad hoc SQL queries to extract, analyze, and validate data from the Eligibility Data Warehouse. • Design, create, and maintain reports and dashboards using SQL-based reporting tools to support operational and regulatory reporting needs. • Perform data quality checks, troubleshoot reporting issues, and ensure data accuracy, consistency, and compliance with state and federal guidelines. • Assist stakeholders with data interpretation and provide guidance on the appropriate use of reports and analytics. • Support ongoing enhancements, integrations, and process improvements related to data reporting and analytics solutions. • Participate in gap analysis, change management activities, and continuous process improvement initiatives. • Differentiate between system defects and new or enhanced business requirements and support appropriate resolution efforts. • Design, develop, and execute test plans; create or collect test data; and perform testing to validate application logic and reporting accuracy. • Identify and document data security requirements and ensure adherence to applicable security standards. • Develop training materials and deliver training or technical support to end users on reporting tools, processes, and best practices. Required Skills and Qualifications • Strong experience in business and data analysis within a data warehouse or reporting environment. • Proficiency in SQL for data extraction, validation, and analysis. • Experience creating reports and dashboards using SQL-based reporting tools. • Ability to translate complex business requirements into clear technical and reporting specifications. • Knowledge of data quality assurance, testing methodologies, and SDLC processes. • Strong communication skills with the ability to work effectively with both technical and non-technical stakeholders. • Experience working in government, healthcare, or public assistance program environments is preferred. Equal Employment Opportunity (EEO) Statement Trilyon, Inc. is an Equal Opportunity Employer committed to diversity, equity, and inclusion. We do not discriminate on the basis of race, color, religion, gender, gender identity, sexual orientation, national origin, age, disability, veteran status, or any other protected class under applicable law. Our diverse workforce drives innovation, creativity, and competitiveness, making us stronger and more adaptable. How to Apply Send your resume to aakanksha@trilyonservices.com or comment “Interested” and I’ll reach out!