Trilyon, Inc. · 1 day ago
Business Intelligence Data Warehouse Consultant
Trilyon, Inc. is a leader in global workforce solutions specializing in Cloud Technology and emerging technologies. They are seeking a Data Warehouse Business Analyst / Reporting Analyst to support the Data Warehouse Team by translating business needs into actionable data and reporting solutions.
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
Qualification
Required
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
Preferred
Experience working in government, healthcare, or public assistance program environments