Title: Senior Data Warehouse Business Analyst / Sr Reporting and DWH Business Analyst
Location: Boston, MA
Duration: 12 Months
Rate: Negotiable
Job Summary:
The Senior Business Analyst (Reporting and Data Warehouse) will play a pivotal role in supporting DTA s data strategy by managing and enhancing data warehouse solutions and reporting structures. This individual will work with stakeholders across the organization to understand reporting needs, optimize data flows, and support the development of dashboards and reports using tools such as Tableau, Cognos, and other reporting technologies. The role requires strong analytical skills, a deep understanding of data management principles, and the ability to bridge technical and business requirements.
Key Responsibilities:
1. Requirement Gathering and Analysis
o Collaborate with DTA s business teams and stakeholders to gather and document requirements for reporting and data warehouse improvements.
o Analyze data needs and reporting requirements to develop solutions that support the organization s data strategy.
o Prioritize and translate business requirements into technical specifications, focusing on data extraction, transformation, and loading (ETL) processes and reporting solutions.
2. Data Warehouse Design and Optimization
o Work closely with data engineering teams to define and enhance data models and ETL workflows in the data warehouse.
o Support the integration of data from DTA s application databases and various state/federal entities.
o Optimize data pipelines and processing workflows to ensure efficient and timely data delivery for reporting purposes.
3. Reporting Development and Support
o Oversee the design and development of reports and dashboards using tools like Tableau, Cognos, and Jasper Reports, ensuring alignment with business needs.
o Provide guidance on best practices for report development and dashboard design to ensure data accuracy, usability, and performance.
o Conduct testing and validation of reports and dashboards, working closely with QA and development teams to resolve any issues.
4. Data Quality and Governance
o Ensure compliance with data quality standards, data protection regulations, and governance policies throughout reporting processes.
o Regularly audit data flows and reports to maintain accuracy and consistency across the organization.
o Document data lineage, data dictionaries, and other artifacts essential for maintaining a reliable data environment.
5. Documentation and Training
o Develop comprehensive documentation, including report specifications, data dictionaries, and process workflows.
o Create training materials and conduct training sessions for end-users, providing ongoing support for business analysts and executives using reporting tools.
o Gather feedback from users to continuously improve reporting functionalities and optimize the data warehouse structure.
6. Technology Assessment and Recommendations
o Stay informed about new technologies in data warehousing, ETL, and reporting to recommend improvements in DTA s data infrastructure.
o Collaborate with IT and data strategy teams to explore new tools, methods, and best practices, particularly with cloud-based solutions like Snowflake.
Qualifications:
Education: Bachelor s degree in Data Science, Information Systems, Computer Science, or a related field.
Experience:
o 5+ years of experience in business analysis with a focus on data warehousing and reporting solutions.
o Demonstrated experience in managing and optimizing data flows, ETL processes, and data models.
o Strong familiarity with data visualization tools, specifically Tableau, Cognos, and Jasper Reports.
Technical Skills:
o Proficiency with data warehouse platforms (e.g., Oracle, Snowflake) and ETL tools such as Informatica.
o Hands-on experience with SQL for data analysis, transformation, and reporting.
o Familiarity with cloud data technologies, especially Snowflake, and experience working on Unix, Linux, and Windows OS.
Soft Skills:
o Strong analytical and problem-solving skills with meticulous attention to detail.
o Excellent communication and interpersonal skills, capable of working effectively with technical and non-technical stakeholders.
o Proven ability to manage multiple projects, prioritize work, and meet deadlines in a dynamic environment.
Preferred Qualifications:
Advanced degree in Data Science, Information Systems, or a related field.
Certification in data warehousing or business intelligence tools.
Experience in cloud-based data platforms and familiarity with data governance and data protection regulations.
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.
Report this job...The Delivery Driver will move merchandise from one location to another. The delivery driver is responsible for collecting and delivering inventory from centers or factories and delivering products to clients without any damage or loss. Supervisory Responsibilities...
...At STERIS, we help our Customers create a healthier and safer world by providing innovative healthcare and life science product and service solutions around the globe. Position Summary As a Precision Assembler you will perform assembly work in a station or line...
...Job Summary This role seeks a Nurse Practitioner to provide comprehensive care to patients across a wide spectrum of womens health... ...with at least one year of experience are preferred, though new graduates are welcome to apply. Job Responsibilities Diagnose...
...certification (e.g., CCP, CEP) certification preferred. Experience on federal facilities programs and large, multi-phase projects.... ...assumptions. Perform change order pricing and evaluate contractor proposals, including detailed analysis of cost build-ups and schedule...
...hospital: Critical Access - Trauma Center: Level IV - Daily census: 10 What to do in Omak: - Outdoor hiking - Lake Omak - fishing, kayaking, swimming, boating - Omak Stampede - 32 mins away from skiing and snowboarding at Loup Loup Ski Bowl - 55 mins away from skiing and...