Guild Mortgage logo
Guild Mortgage

In neighborhoods and communities everywhere, we deliver the promise of home.

Senior Data Analyst

Data AnalystData AnalystFull TimeRemoteSeniorTeam 1,001-5,000Since 1960H1B No SponsorCompany SiteLinkedIn

Location

United States

Posted

61 days ago

Salary

$109.1K - $156.5K / year

Seniority

Senior

Job Description

Senior Data Analyst

Guild Mortgage

• Partner with key stakeholders, including the business unit leaders, Product, Data & Technology teams, to assess their data and analytics needs by eliciting data requirements, and researching internal systems of record and publicly available data sources and assessing their quality of data. • Requisition and obtain private data sources to support business needs for data and insights. • Identify translation or transformation requirements for sourced data into the data warehouse. • Improve quality of sourced data by data curation and validation rules as well as maintaining the Master Data tables. • Maintain the Logical Data Dictionary (LDD) with data lineage information (field definition, domain, source system, intermediary and destination system(s), translations, transformation rules, display screens, referenced reports, etc.), Data Stewards and Data Custodian info along with versioning for historic analysis and audit trail. • Ensure consistent delivery of high-quality insights to key stakeholders by reconciling and validating dashboards and reports in a timely manner. • Document functional / non-functional business requirements for collecting, loading, transforming, curating, processing data and for visualization and distribution of insights. • Identify internal process improvements for automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc. • Provide actionable insights using analytics tools into customer acquisition, operational efficiency and other key business performance metrics. • Identify Personally Identifiable Information (PII) data in primary data sources as well as in data architecture, define masking and other data processing rules for special handling of PII data as well as maintain access control lists for visibility of PII data on a need-to-know basis. • Identify and document the Business Continuity Plan/Disaster Recovery (BCP/DR), and technical requirements for high availability and recoverability for the data architecture. • Improve the quality of data used for analysis by assessing the accuracy of new data sources and the effectiveness of new data gathering techniques. • Define Key Performance Indicators (KPIs) and document technical processes to monitor and analyze data warehouse performance and data accuracy. • Contribute to the team of data professionals by using expertise to answer questions and sharing templates, reusable artifacts with less experienced teammates, enhancing skillsets and competencies of team members, and sharing business domain knowledge throughout the team. • Participate in stakeholder reviews and design sessions. • Provide data, reports, and information to management as needed. • Identify, track, and monitor trends and avoidable technology-related errors; work across functions to develop complex solutions, improvements, and stop-gaps. • Focus on the continual improvement of policies, procedures, and processes falling under scope of authority. • Use expertise to resolve high level issues that cannot be solved by teammates. • Stay abreast of latest technology trends and participate in high-level decisions impacting the direction of Information Technology function. • Consistently monitor and model platform usage, database sizes, compute resources and third- party costs to ensure that the data team’s spend is as cost-efficient as possible. • Champion data transformation to new ways of working and generating insights. • Drive strong communications, partnerships, and stakeholder management with senior leaders, functional managers and staff. • Perform other duties as assigned.

Job Requirements

  • Bachelor's Degree in Computer Science, Data Science or related quantitative field is required.
  • Master’s Degree in business administration (MBA) or related to the position or equivalent, preferred.
  • Minimum 5 years' experience in Data Analyst related role(s) and two of those years spent in a senior technical level role(s) required.
  • Highly proficient with eliciting business requirements, documenting user stories, analyzing data sources, and assessing data quality.
  • Highly proficient in data analysis, technical documentation, logical data dictionary, data validation rules, acceptance criteria, software development lifecycle (SDLC) such as Scrum and IT Service Management (ITSM) – ITILv4.
  • Experience in identifying data integrations needs using Extract, Transform and Load (ETL) tools and modern data pipes.
  • Proven experience with querying and analyzing data from SQL relational databases such as AuroraDB, IBM DB2, MemSQL, MS SQL Server, MySQL, Postgres, Snowflake, and NoSQL Databases such as Cassandra, DynamoDB, Redis, MongoDB.
  • Experience collecting structured, semi-structured and unstructured data in various popular formats and sourced from internal core systems as well as 3rd partner providers such as Google Analytics, Facebook Insights, Zillow, CoreLogic, MLS Data, Public Records, and Property Data.
  • Experience using collaboration tools such as Microsoft Office or Google G-Suite as well as Jira, Confluence, and Microsoft SharePoint.
  • Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement.
  • Strong analytical skills to document processes supporting data transformation, data structures, metadata, dependency and workload management.
  • Strong data governance skills to ensure highest quality of data is made available for data analysis and accuracy in reporting.
  • Problem solver with an ability to work as a team towards a solution.
  • Ability to prioritize multiple tasks in a deadline-driven environment, strong sense of urgency and responsiveness.
  • Strong detail orientation and highly organized with proven ability to lead effectively and drive results in a matrixed management environment.
  • Ability to think critically, including the ability to evaluate facts and data to draw conclusions, determine the downstream impact of decisions and associated risks.
  • Excellent verbal and written communication skills plus demonstrate strong leadership capabilities.
  • Strong interpersonal and team building skills.
  • Self-starter with the demonstrated ability to learn/adapt to new technologies and techniques.
  • Excellent verbal and written communication skills required.
  • Highly organized and detail-oriented; ability to work in a fast-paced, metrics-driven environment required.
  • Proficiency in Microsoft Office Suite, Word, Excel, Wiki, collaborative cloud-based programs, and third-party software applications required.
  • Commitment to company values.

Benefits

  • medical
  • dental
  • vision
  • life insurance
  • AD&D
  • LTD
  • 401(k) with employer match

Related Categories

Related Job Pages

More Data Analyst Jobs

We are seeking an On-Chain Data Analyst to strengthen the firm’s on-chain research capabilities by internalizing and systematizing critical data and attribution workflows. This role is central to improving the quality, reliability, and scalability of on-chain research used to inform market analysis and investment decision-making. The ideal candidate is an experienced on-chain engineer or data professional who is comfortable operating close to research. You will work in a highly dynamic, market-driven environment, translating ambiguous research questions into research‑grade datasets, improving entity‑level attribution, and helping evolve ad‑hoc analysis into durable systems. Responsibilities - Build and maintain EVM-chain attribution and labeling datasets, including address labeling (exchanges, whales, protocols, DAOs), entity clustering, and QA to ensure research-grade data quality. - Translate research questions into reproducible datasets and analytical workflows, including token supply/distribution tracking, exchange flow analysis, and entity-level behavioral views that researchers rely on for ongoing analysis. - Systematize coverage of token launches, airdrops, and distribution events by creating reusable templates and frameworks that reduce ad-hoc coverage effort. - Support ownership transitions of infrastructure components (label database, on-chain monitor) to the Data Platform Team through technical specifications and documentation, acting as a subject-matter bridge between research and engineering teams during handoff phases. - Validate research assumptions, edge cases, and data correctness in analysis outputs and dashboards. - Conduct exploratory analysis using attribution datasets to identify behavioral patterns, reduce noise, and surface potential market-relevant signals.

United Kingdom
Dadosfera logo

Junior Data Analyst

Dadosfera

O caminho mais rápido entre Dados e Valor

Data Analyst61 days ago
Full TimeRemoteTeam 51-200Since 2018H1B No Sponsor

• Assist with extracting, cleaning, and preparing datasets for analysis. • Contribute to the development of basic reports and data visualizations for internal stakeholders and clients. • Analyze patterns and trends in data, supporting the use of statistical models and machine learning. • Collaborate with business teams to provide actionable insights. • Support the identification of data quality issues and assist in their resolution.

Brazil
Job Closed

About the role - We are seeking a Senior Program Controls Analyst to lead cost and earned value management efforts on complex, mission-critical programs within aerospace and defense environments. - This role is responsible for driving program financial integrity, ensuring forecasts reflect execution reality, and providing leadership with clear, decision-quality insight. You will operate as a trusted partner to Program Managers and Control Account Managers (CAMs), owning the financial narrative of the program. What you'll do - Lead development and maintenance of program cost baselines, including time-phased budgets and control account structures - Own Earned Value Management (EVM) processes within Deltek Cobra, ensuring data integrity and compliance with EVMS guidelines - Develop, analyze, and defend Estimates at Completion (EAC) and Estimates to Complete (ETC) - Perform deep-dive variance analysis and clearly articulate root causes, impacts, and forward-looking risks - Partner directly with CAMs and program leadership to validate performance, challenge assumptions, and improve forecast accuracy - Lead monthly program financial reviews, including internal leadership briefings and customer-facing deliverables - Reconcile cost, schedule, and accounting data across systems (Cobra, ERP, timekeeping) to ensure consistency and audit readiness - Support baseline change control processes, including BCR development, impact analysis, and implementation - Ensure compliance with ANSI/EIA-748 EVMS guidelines and support DCMA/DCAA audits and surveillance activities - Identify cost risks and opportunities and proactively drive mitigation strategies Qualifications - 7+ years of experience in program controls, cost management, or earned value management - Advanced, hands-on experience with Deltek Cobra (required) - Strong expertise in EVMS principles and ANSI/EIA-748 compliance - Proven experience developing and defending EACs/ETCs at the program or control account level - Experience working directly with CAMs and program leadership in a client-facing environment - High proficiency in Excel and large dataset analysis - Strong ability to translate complex financial data into clear, actionable insights - Experience in aerospace and defense required - Experience with Deltek Costpoint or equivalent ERP systems - Background supporting DCMA or DCAA audits, IBRs, or surveillance reviews - Familiarity with integrated cost/schedule environments and cross-functional program controls - Experience leading or mentoring junior analysts - Active or eligible for a U.S. security clearance

United States
Crown Innovations, Inc. logo

Energy Data Analyst

Crown Innovations, Inc.

Crown Innovations is a recognized leader in research, development, and engineering with deep expertise in air traffic management, infrastructure modernization, lifecycle data management, and National Airspace System integration. Crown supports a wide portfolio of federal and commercial clients including the FAA, NASA, the Energy Information Administration, and state transportation agencies. Crown has consistently been voted one of the best places to work in the Washington DC area.

Data Analyst61 days ago
Full TimeRemoteTeam 201-500

Role Description Crown Innovations is seeking an Energy Data Analyst to support survey operations for the U.S. Energy Information Administration (EIA). This role supports the full survey lifecycle, including data collection, analysis, and report publication. The Energy Data Analyst will work as part of an integrated team and assist in the analysis of data collected through weekly, monthly, and annual surveys. This position serves as a frontline communicator with survey respondents, supporting data validation efforts, troubleshooting reporting issues, and resolving anomalous data submissions. This is a fully remote position. This role offers exposure to federal data programs and provides opportunities to build expertise in large-scale data analysis, survey operations, and government reporting processes, with potential for expanded responsibility over time. Qualifications - Bachelor’s degree in a relevant field or equivalent combination of education and experience - Must be a U.S. citizen - Must be available during core required hours - Reliable at-home internet connection Requirements - Proficiency with computers, including customer relationship management software and strong typing skills - Strong time management and decision-making skills - Ability to recognize emerging trends and patterns and respond to changing customer concerns - Strong organizational skills with the ability to manage multiple tasks in a fast-paced environment - Excellent attention to detail and analytical capabilities - Professional and confident communication skills with leadership, peers, customers, and government counterparts - Ability to work effectively with various stakeholders including contractors, team members, and federal personnel - Adaptability to changing processes and openness to constructive feedback - Dependable team member with a collaborative mindset and willingness to support team objectives Benefits - Medical insurance and prescription drug coverage - Dental insurance - Vision insurance - Life and AD&D insurance - Long-term disability insurance - Short-term disability insurance - 80 hours paid vacation annually - 40 hours paid sick leave annually - 11 paid holidays - Retirement plan

United States
$46K - $50K / year