Senior Data Analyst na Cumminggroup

At Cumming Group, you will work on some of the world's most exciting projects in a dynamic environment where your success is measured by the impact you make. We are one of the fastest-growing project and cost management consultancies in the United States, as reflected in our top 10 rankings in ENR. With over 60 offices globally, an extremely diverse project portfolio, and double-digit year-over-year revenue growth, the opportunities to make your mark are limitless!

The Senior Data Analyst plays a pivotal role in transforming data into actionable insights that drive business decisions and operational excellence across the organization. As a senior member of the Data Team—part of the IT Division—the analyst will lead advanced data modeling, analytics, and visualization efforts, while mentoring peers and ensuring adherence to data governance and quality standards.

This position partners closely with stakeholders across Finance, Operations, HR, and Project Management to deliver trusted data solutions from our Azure Databricks Lakehouse and connected systems (Deltek Vantagepoint, Dynamics 365, Workday, and others). The ideal candidate is highly analytical, self-driven, and passionate about leveraging data to enable smarter business outcomes.

Essential Duties & Responsibilities:

• Lead advanced analytical projects using data sourced from the company’s Azure Databricks lakehouse, ensuring outputs align with strategic business objectives.
• Design and develop Power BI dashboards leveraging Microsoft Fabric capacity and robust data models for scalability, governance, and performance.
• Build and maintain data models and transformations in Databricks SQL using Delta tables, Unity Catalog, and Lakehouse architecture best practices.
• Collaborate with data engineers to enhance ingestion pipelines using Fivetran, Workato, REST APIs, and other connectors.
• Perform exploratory and diagnostic analyses using SQL, Python (pandas, numpy), and Power BI to uncover business trends, inefficiencies, and improvement opportunities.
• Ensure data quality and lineage through established data governance frameworks, including metadata documentation, business glossary maintenance, and data issue management.
• Develop stored procedures and SQL logic to support operational systems such as Deltek Vantagepoint and related financial integrations.
• Collaborate with business stewards and system owners to validate data accuracy and drive consistency across departments.
• Mentor junior analysts and help define Power BI development standards, DAX best practices, and model optimization techniques.
• Communicate insights effectively through visual storytelling, executive dashboards, and data narratives tailored for non-technical audiences.

Knowledge & Skills Required:

• Expert-level SQL skills, including complex joins, window functions, and performance tuning across large datasets.
• Proficiency in Power BI (data modeling, DAX, deployment pipelines, and governance in Fabric).
• Working knowledge of Azure Databricks, including Databricks SQL (ANSI SQL), notebooks, Delta tables, and data lakehouse principles.
• Advanced Microsoft Excel skills (pivot tables, advanced formulas, charts, and VBA scripting preferred).
• Competency in Python for analytics, data cleaning, or automation (preferred: pandas, pyodbc, requests).
• Understanding of data governance concepts—metadata, lineage, data quality, and business glossary management.
• Experience with REST APIs and JSON data structures.
• Knowledge of dimensional modeling and best practices for data warehousing.
• Exposure to Deltek Vantagepoint, Dynamics 365, or similar ERP/CRM systems is a plus.
• Strong analytical mindset with exceptional attention to detail and ability to translate data into business recommendations.

Preferred Education and Experience:

Education: Bachelor’s degree in computer science, information systems, data science, business analytics, or another related field

Experience: Required 5-7 years of relevant technical or business work experience. Project management experience highly desirable. Microsoft Certification PL-300 (Power BI Data Analyst) or DP-900 / Databricks Certified Data Analyst preferred.

#LI-SJ1

Cumming Group is committed to providing Equal Employment Opportunity in its personnel policies and practices. It is Cumming Group’s policy to recruit, hire, train and promote Team Members and applicants for employment without regard to race, color, creed, religion, age, sex, marital status, registered domestic partner status, genetic information, sexual preference, sexual orientation, gender (including gender expression and gender identity), pregnancy (including childbirth or related medical conditions, including breastfeeding), military service, national origin, ancestry, citizenship, physical disability, mental disability, veteran status or any other protected classification under federal, state, or local law. All such decisions are based on (1) individual merit, qualifications, and competence as they relate to the particular position, and (2) promotion of the principle of equal employment opportunity.

All other terms and conditions of employment, such as compensation, benefits, transfers, layoff, return from layoff, training, education, and social and recreational programs, are administered without regard to the characteristics described above. To this end, Cumming Group complies with all provisions of Title VII of the Civil Rights Act of 1964 as amended, all of the rules, regulations and relevant orders of the Secretary of Labor, and all similar state and local laws.

 

The salary range for this full-time role is $102,300.00-$136,433.35 per year. Ranges are determined based on the position, geography, client and industry experience and level, and represent a good faith effort to provide a fair and equitable salary. This range reflects base salary only, and not the total compensation package. Cumming Group reserves the right to pay more or less than the posted range, depending on a candidate’s experience, skills, and qualifications, including client requirements.

In addition to base salary, Cumming Group offers a comprehensive benefits package including:

• Medical
• Dental Insurance
• Vision Insurance
• 401(k)
• 401(k) Matching
• Paid Time Off
• Paid Holidays
• Short and long-term disability
• Employee Assistance Program

Candidatar-se agora