Senior Data Analytics Specialist

Delmock Technologies - Laurel, MD

Full-time - Senior

Hybrid - Laurel, MD

Professional, Scientific, and Technical Services

About the position

The Senior Data Analytics Specialist at Delmock Technologies, Inc. plays a crucial role in designing and implementing enterprise-wide business intelligence and data solutions. This position requires expert knowledge of Oracle C2M and utilities application data structures, along with extensive experience in data solutions for Oracle utilities and billing applications. The specialist will develop dashboards and reporting solutions, collaborate with stakeholders to understand analytical needs, and utilize various BI tools to deliver impactful insights from complex datasets.

Responsibilities

• Define systemic or specific problems and analyze and develop plans and requirements for execution or transformation in the subject matter area for moderately complex-to-complex systems.
• Coordinate and manage the preparation of analysis, evaluations, and recommendations for proper implementation of programs and systems specifications.
• Create and maintain documentation for reports, dashboards, and related processes.
• Provide technical support to end-users for BI solutions.
• Collaborate with business users to gather reporting requirements and design reports and dashboards that meet their needs.
• Manage, administer, and develop analytics solutions using Oracle Analytics, Microsoft Power BI, and BI Publisher.
• Validate report output by cross-referencing it with data from the Oracle C2M system, identifying any data discrepancies or anomalies.
• Incorporate new data sources and analytics features into reports, as requested by stakeholders.
• Modify and customize existing reports based on evolving business needs, providing ongoing support for report enhancements.
• Continuously explore new tools and techniques for improving reporting efficiency and effectiveness.
• Provide training and support to end-users on how to use reports and dashboards.
• Design, develop, and maintain robust and scalable data pipelines for various data sources.
• Design and implement data models for Oracle C2M and utilities applications, ensuring data integrity and consistency.
• Build and maintain data warehouses and data lakes to support analytics and reporting needs.
• Develop and maintain reports, dashboards, and visualizations using BI tools to provide insights into Oracle Utilities application data.

Requirements

• A Bachelor's Degree from an accredited college or university in Computer Science, Information Systems, Engineering, Business, or related discipline.
• Seven (7) years of experience in IT.
• Five (5) years of hands-on or analysis experience in Data Analytics.
• Expert Knowledge of Oracle Primavera P6 Analytics implementation and experience in the construction domain.
• Experience with various BI tools like Oracle Analytics, BI Publisher, and Microsoft Power BI.
• Strong experience in Oracle Analytics Server Administration.
• Experience in designing and implementing data models for Oracle C2M applications.
• Experience in analyzing Oracle C2M application data to identify trends, patterns, and insights.
• Proficiency in writing complex SQL queries to extract and analyze data from C2M tables and views.
• 8+ years of experience designing and implementing data solutions and dashboard development for Oracle C2M, P6 analytics at enterprise-level applications.
• Strong understanding of utility applications and billing systems, especially within Oracle utilities (C2M, CC&B).
• Demonstrated experience working on large-scale data projects in diverse team environments.
• 5+ years of experience working with Oracle C2M, including in-depth knowledge of its data structures and capabilities for utilities and billing applications.
• Extensive experience with data modeling and database design, particularly for Oracle-based applications and BI platforms.
• Proven expertise in implementing enterprise-wide analytics and business intelligence solutions.

Nice-to-haves

• A Master's Degree is preferred.