Office365

Office365 Data Jobs

3 jobs found

6d ago

Analytics Engineer

Cox Automotive Atlanta, GA

Atlanta, GA

6d ago

$102k - $169k/yr Full time Adobe Analytics Analyst Analytical Skills

Apply Now

Job Description

Analytics Engineer role at Cox Automotive in Atlanta, GA (onsite) with a salary range of USD 101,500 to 169,100 per year.

Responsibilities

Partner with cross-functional teams to drive data informed decision making for growth and business optimization.
Build and maintain foundational assets such as a Data Dictionary and a Query Repository, establishing standards and traceability for monitoring the health of Cox Automotive Consumer & Marketing Solutions products; collaborate with stakeholders to optimize these assets.
Collaborate with analysts to define data asset requirements, translating metrics and use cases into asset development based on database schemas or by coordinating with data scrum teams; identify opportunities to optimize assets with a focus on runtime performance.
Support the development and maintenance of data models using dbt and SQL transformations deployed to Snowflake, following a lifecycle from stakeholder intake to production deployment.
Participate in version controlled development workflows using GitHub, including branching, pull requests, code reviews, and CI/CD processes to ensure reliable data deployments.
Maintain data lineages that document metrics in each report, their queries, and data sources; proactively suggest improvements to documentation to ease future updates and troubleshooting.
Contribute to semantic layer documentation and metadata to enable AI powered analytics tools to interpret natural language queries against business data.
Develop and maintain anomaly detection and alerting capabilities for data assets; continuously improve detection methods and thresholds to ensure data quality.
Apply advanced analytics methods and collaborate with analysts or scrum teams to identify root causes of data anomaly alerts.
With limited manager oversight, administer access to analytics tools.
Support BI tool strategy projects with leadership, focusing on optimizing platforms to align with analytics needs.
Maintain and optimize technologies that enable the analytics practice and team operations, including SharePoint, operational insights, and various automation such as insights and workflow automation.
Leverage AI and GenAI applications to augment task execution, improve workflow efficiency, and accelerate delivery of analytics deliverables.
Learn and apply analytics technologies (web analytics tools, SQL-based databases, data visualization software, AI/GenAI capabilities) and coordinate with vendors to resolve issues.
Support Analytics Leads or other leaders on company initiatives; may lead project execution to meet milestones after aligning with leadership.
Guide other analysts on advanced techniques and validate their work.
Collaborate with managers to define priorities and deliver against business goals, working independently and with cross-functional teams.
Operate with limited supervision; proactively optimize existing solutions.
Travel up to 5 percent for same-day or overnight business trips.
Perform other related duties as assigned.

Requirements

Authorized to work in the United States for any employer without current or future sponsorship; no OPT, CPT, STEM OPT, or visa sponsorship now or in the future.
Residence within commutable distance to the Atlanta office.
Bachelor's Degree and 6+ years of experience, or 18 years of related experience.
Intermediate SQL programming skills and knowledge of SQL based relational databases; experience with ETL processing of big data.
6+ years experience with SQL based relational databases (e.g., Athena, Redshift, Snowflake); Snowflake preferred.
6+ years experience with BI tools (Power BI, Domo, Tableau).
Strong Microsoft Excel skills; proficiency with the Microsoft Office Suite.
Web analytics knowledge (Google Analytics, Adobe Analytics) highly preferred.
Experience with data transformation tools such as dbt, including model development, testing, and documentation preferred.
Familiarity with version control systems (GitHub) and CI/CD workflows for data pipeline deployment.
Experience with or willingness to learn Snowflake capabilities, including Cortex AI features for semantic layer and natural language analytics.
Previous experience with AI/GenAI applications to augment tasks or workflows, including AI assisted development tools (Claude Code, GitHub Copilot).
Ability to learn and apply AI/GenAI capabilities as part of analytics operations, including using large language models for code generation, documentation, data quality analysis, and automation.
Previous experience with machine learning or automation, especially anomaly detection, threshold setting, or natural language generation, a plus.
Tableau Server certification and AWS Data Analytics certification are pluses.
Ability to work directly with vendors to resolve issues and support long term projects and initiatives.
Willingness to learn and use analytics technologies (web analytics tools, work management software, AI/GenAI capabilities).
Demonstrated ability to build relationships and collaborate across teams; capable of consulting stakeholders for optimal outcomes.
Ability to anticipate stakeholders' needs and provide proactive solutions that strengthen partnerships.
Ability to develop scalable processes and standards to improve team efficiency.
Excellent communication skills; able to present findings clearly to stakeholders and translate analytical insights into a cohesive narrative.
Creative problem solver who questions assumptions and tests hypotheses with data; translates requests into actionable tasks with timelines.
Strong organizational and prioritization skills in a deadline-driven, evolving environment; flexible and adaptable to agile workflows.
Proactive, self-motivated, with curiosity and a commitment to continuous learning in the digital and automotive spaces.
Travel up to 5 percent.

Technologies

dbt
SQL
Snowflake
GitHub
Power BI
Domo
Tableau
Excel
Google Analytics
Adobe Analytics
Snowflake Cortex Analyst
Cortex AI
SharePoint

Benefits

Flexible vacation with pay
Seven paid holidays per year
Up to 160 hours of paid wellness annually
Bereavement leave
Time off to vote
Jury duty leave
Volunteer time off
Military leave
Parental leave

Compensation

Base salary range: USD 101,500 to 169,100 per year
Salary may vary by location and candidate knowledge, skills, and abilities
Potential eligibility for additional compensation such as incentive programs

View full job page →

7d ago

Data Analyst / Dashboard Developer (Secret Clearance)

System One Hampton, VA

Hampton, VA

7d ago

Full time Analyst Analytical Skills Analytics

Apply Now

Job Description

The Data Analyst / Dashboard Developer will design, implement, and maintain a live Performance Dashboard with automated data integration to support ACC leadership. This onsite role in Hampton, VA requires a Secret clearance and the ability to obtain TS/SCI.

Responsibilities

Build and deploy the live Performance Dashboard within 60 days of contract award on Power BI hosted on FedRAMP authorized or DAF365 platforms
Token and License Management System (TLMS) – token allocation, utilization, compliance status by wing and directorate
Learning Management System (LMS) – training completions, assessment scores, proficiency tracking
Help Desk Ticketing System – response times, resolution rates, recurring issue categories
Integrated Master Schedule (IMS) – task completion, schedule performance, milestone tracking
Workflow Development Pipeline – prototype status, transition timelines, ROI documentation
Training completions prior to access grant
Token and license utilization by wing and directorate
AI and RPA workflow development and transition status
Help desk response and resolution rates
Travel execution against approved wing visit schedules
Quarterly performance trends and year-over-year comparisons
Establish automated data pipelines from source systems to the dashboard with daily refresh cycles, or more frequent where technically feasible
Validate data accuracy through cross-referencing with source system reports and manual audits
Identify and resolve data quality issues including missing records, duplicate entries, and classification mismatches
Coordinate with the Token/Resource Administrator, Help Desk Analysts, and Program Analyst to ensure source data integrity
Document all data transformation logic, calculation methodologies, and business rules in technical specifications
Maintain a data dictionary defining every metric, dimension, and KPI displayed on the dashboard
Generate comprehensive Quarterly Performance Brief data packages for PM and COR review 5+ business days before scheduled briefs
Produce executive summary slides showing KPI trends, QASP standard compliance, and performance variance analysis
Develop drill-down appendices with wing-level breakouts, directorate comparisons, and time-series trend charts
Coordinate with the Stakeholder Engagement & KM Specialist to package metrics into governance-ready narratives
Prepare data visualizations optimized for executive audiences (clear, concise, actionable)
Document all data sources, assumptions, and calculation methods for COR transparency
Conduct monthly service desk trend analysis identifying Top 10 recurring issue categories requiring knowledge base articles or training updates
Response and resolution time performance against QAP standards
Ticket volume trends by wing, directorate, and platform
Knowledge gaps indicating curriculum deficiencies
Platform issues requiring vendor escalation or technical advisory engagement
Deliver service desk analysis reports to the Deputy PM within 5 business days of each month close
Track time from knowledge gap identification to updated training deployment as a mandatory KPI
Measure knowledge base utilization impact on ticket volume reduction over time
Analyze token and license utilization patterns to identify underutilized allocations suitable for reallocation
Analyze token and license utilization patterns to identify high-demand wings requiring additional resource allocation
Analyze token and license utilization patterns to identify cost-sharing opportunities across participating wings
Analyze token and license utilization patterns to identify compliance gaps where users received tokens without completing training
Generate monthly utilization reports for the Token/Resource Administrator showing allocation efficiency and compliance status
Produce cost-per-user and cost-per-wing analytics supporting ACC budget planning
Forecast future resource requirements based on training completion trends and wing expansion plans
Respond to ad hoc data requests from the PM, COR, and functional leads within 2 business days
Conduct root cause analysis when KPIs fall below QASP thresholds, identifying contributing factors and corrective action recommendations
Support RAID log population with data-driven risk assessments and impact quantification
Perform comparative analyses across wings to identify best practices and adoption barriers
Develop predictive models forecasting training completion rates, token demand, and workflow development throughput
Dashboard operational within 60 days of contract award with all six PWS KPI categories integrated
Daily data refresh cycles maintained with 99% plus uptime (excluding planned maintenance)
Quarterly performance brief data packages delivered 5+ business days before scheduled briefs with zero data accuracy issues requiring correction
Monthly service desk trend analysis delivered within 5 business days of month close
Ad hoc analysis requests completed within 2 business days of PM/COR request
Data quality audits conducted quarterly with findings documented and corrective actions implemented within 10 days

Technologies

Power BI
Power Automate
Microsoft Excel (Power Query, Power Pivot, DAX)
SQL
DAF365
SharePoint
LMS
TLMS

Schedule and Availability

Core Hours: 0800-1700 EST, Monday-Friday
Flexibility: Occasional early morning or evening meetings to accommodate wing schedules across time zones
Surge Periods: Increased hours during major milestones, events, or exercises with advance notice

Security Environment

Work with classified information up to Top Secret/SCI level
Compliance with OPSEC, CUI handling, and classification protocols
Subject to security inspections, audits, and continuous evaluation
Adherence to base access, badge, and facility security requirements

Performance Expectations

Dashboard operational within 60 days of contract award with all six PWS KPI categories integrated
Daily data refresh cycles maintained with 99% plus uptime (excluding planned maintenance)
Quarterly performance brief data packages delivered 5+ business days before scheduled briefs with zero data accuracy issues requiring correction
Monthly service desk trend analysis delivered within 5 business days of month close
Ad hoc analysis requests completed within 2 business days of PM/COR request
Data quality audits conducted quarterly with findings documented and corrective actions implemented within 10 days

View full job page →

19d ago

Data Analyst

One Federal Solution Washington, DC

Washington, DC

19d ago

Full time Adoption Dashboard Analyst Analytical Skills

Apply Now

Job Description

Data Analyst position with One Federal Solution in Washington, DC onsite, focusing on data analysis, reporting, and information management within a high-visibility Department of State environment.

Responsibilities

Oversee the collection, receipt validation, and recordkeeping of monthly application registration data from Accrediting Entities (AEs).
Analyze monthly data by country to identify trends, anomalies, areas for improvement, and actionable recommendations.
Produce monthly reports, summaries, and leadership readouts, maintaining supporting materials in OneNote.
Maintain the Adoption Tracking System (ATS) with monthly, semi-annual, and annual data, ensuring data accuracy and integrity across records.
Conduct data reconciliation to remove duplicates and inconsistent naming conventions, upholding consistent data standards across systems.
Monitor changes in Adoption Service Provider (ASP) accreditation status and coordinate timely updates with Accrediting Entities.
Support provider change requests and respond to ATS inquiries from Accrediting Entities, Adoption Service Providers, and government personnel.
Generate country-specific and provider-specific reports to support leadership briefings, travel planning, meetings, and operational analysis.
Utilize the CLEAR Adoption Dashboard within the Consular Launchpad for Enterprise Analytics and Reporting to fulfill data requests and validate reporting accuracy.
Review dashboards and reports for inconsistencies, document discrepancies, and coordinate corrective actions with stakeholders.
Download, manipulate, and analyze data to support ad hoc reporting requirements and leadership requests.
Compile and analyze statistical data for the Annual Report to Congress, including narrative explanations, historical comparisons, trend analysis, and anomaly identification.
Coordinate with internal stakeholders to ensure completeness, accuracy, and timely clearance of annual reporting requirements.
Prepare statistical information for publication on government websites and provide data updates to international stakeholders as required.
Develop meaningful data visualizations, dashboards, charts, and graphics to communicate operational metrics and performance indicators.
Create visual reporting products using complaint registry data, accreditation information, and monthly and semi-annual reporting data.
Prepare executive presentations, briefing materials, and reports using Microsoft PowerPoint and other Microsoft Office applications.
Maintain organized documentation and knowledge management resources within OneNote and SharePoint to support continuity of operations.
Identify opportunities to improve reporting processes, workflow efficiencies, and data quality while ensuring compliance with policies and procedures.
Collaborate effectively with government personnel and cross-functional teams, maintaining professionalism, confidentiality, and strong customer service.

Requirements

Bachelor's degree required; five years of government experience (preferably supporting the Department of State) may substitute for the degree.
Minimum of three years of experience in a professional office environment.
Proven experience analyzing data, identifying trends, and preparing reports for executive or senior leadership.
Strong analytical, organizational, and problem-solving skills with meticulous attention to detail.
Excellent written and verbal communication skills.
Proven ability to manage multiple priorities while meeting deadlines in a fast-paced environment.
Proficiency with Microsoft Office Suite, including Excel, Word, PowerPoint, Outlook, Teams, and SharePoint.
Experience using OneNote for documentation and knowledge management.
Ability to exercise sound judgment, maintain confidentiality, and work independently with minimal supervision.

Technologies

Microsoft Excel
Microsoft Word
Microsoft PowerPoint
Microsoft Outlook
Microsoft Teams
SharePoint
OneNote
Adoption Tracking System (ATS)
Consular Launchpad for Enterprise Analytics and Reporting (CLEAR) Adoption Dashboard
Microsoft Power BI

View full job page →

Office365 Data Jobs

Analytics Engineer

Data Analyst / Dashboard Developer (Secret Clearance)

Data Analyst

Get Office365 Data Jobs alerts