Data Domain Architect - Senior Associate

Fairygodboss; Columbus (OH); On-site; USD 70,000 - 90,000; Full time

Benefits offered by this job

Health care coverage

Retirement savings plan

Tuition reimbursement

Job summary

Fairygodboss is seeking a data analyst in Columbus, Ohio, to contribute to the transformation and modernization of our data environment. The ideal candidate will have 5+ years of experience in data analytics or financial reporting, particularly within home lending.

The role includes responsibilities in operational processes, data reconciliation, and collaboration with IT to drive insights and improvements in our data systems. We offer a competitive total rewards package, including comprehensive health care coverage, retirement savings plan, and more.

Qualifications

• 5+ years of experience in data analytics or financial reporting systems.
• Strong analytical and problem-solving ability.
• Domain knowledge in home lending or mortgage banking.

Responsibilities

• Transform and modernize our data environment.
• Execute operational processes with accuracy.
• Conduct detailed reconciliation of results.

Skills

Data analytics

SQL optimization

Business intelligence analytics

Process improvement

Strong communication skills

Education

Bachelor's degree in relevant field

Tools

Spark SQL

AWS

Microsoft Office Suite

Job description

Job Responsibilities

• Contribute to the transformation and modernization of our data environment to serve the analytical and reporting needs of the CCB Home Lending Finance Organization.
• Execute and take ownership of operational processes with an emphasis on accuracy and timeliness of meeting deliverables on prescribed timetables / calendars.
• Identify hidden problems and patterns in home lending data proactively and use those insights to drive process improvements.
• Conduct detailed reconciliation of results between home lending data systems.
• Work with IT to migrate to production the developed solutions and act as an SME/escalation point for the deployed solutions.
• Provide a high level of responsiveness to ad-hoc requests, "what-if" scenario data analytics, and regulatory inquiries related to home lending.
• Participate in requirements gathering sessions with varying levels of leadership, complete detailed project planning utilizing JIRA to record planned project execution steps.
• Partner with the Technology Team to design and deliver data domains into the Finance Data Mart that brings together essential home lending data categories to enable the Finance function to support their analytical and reporting needs.
• Source and maintain the Financial and Operational data required to transform and maintain Home Lending reporting.
• Become a subject matter expert in our home lending financial reporting platforms and support team members in becoming more proficient themselves.

Required Qualifications, Capabilities, and Skills

• Bachelor's degree in MIS, Computer Science, Finance, Accounting, or other related area with relevant work experience.
• 5+ years of experience in data analytics, architecture, or financial reporting systems, preferably within home lending or mortgage banking.
• Experience with relational databases optimizing SQL to pull and summarize large datasets, report creation and ad-hoc analyses.
• Experience with business intelligence analytics and data wrangling tools
• Domain Knowledge: Deep understanding of the home lending or mortgage banking industry.
• Data Quality Management: Understanding of strategies and tools for data profiling, cleansing, and validation to maintain high data quality.
• Demonstrated experience delivering process improvement or automation.
• Highly motivated, self-directed, curious to learn new technologies, strong team player.
• Strong analytical and problem-solving ability; Excellent written and verbal communication skills.
• Experience in reporting development and testing, and ability to interpret unstructured data and draw objective inferences given known limitations of the data.
• Strong knowledge and experience with data management, data lineage, data dictionaries, and making data discoverable.

Preferred Qualifications, Capabilities, and Skills

• Experience with Spark SQL or other big-data query tools.
• AWS, Databricks, Snowflake, or other Cloud Data Warehouse experience.
• Hyperion Essbase cube design and administration experience.
• Experience eliminating user tools, saving time, and increasing ability to generate insights through data, dashboards, and developing new capabilities.
• Proficient user of the Microsoft Office Suite (primarily Excel).

Benefits

We offer a competitive total rewards package including base salary determined based on the role, experience, skill set and location. Those in eligible roles may receive commission-based pay and/or discretionary incentive compensation, paid in the form of cash and/or forfeitable equity, awarded in recognition of individual achievements and contributions. We also offer a range of benefits and programs to meet employee needs, based on eligibility. These benefits include comprehensive health care coverage, on-site health and wellness centers, a retirement savings plan, backup childcare, tuition reimbursement, mental health support, financial coaching and more. Additional details about total compensation and benefits will be provided during the hiring process.

Equal Opportunity Employment and EEO Statement

Equal Opportunity Employer/Disability/Veterans.

We recognize that our people are our strength and the diverse talents they bring to our global workforce are directly linked to our success. We are an equal opportunity employer and place a high value on diversity and inclusion at our company. We do not discriminate on the basis of any protected attribute, including race, religion, color, national origin, gender, sexual orientation, gender identity, gender expression, age, marital or veteran status, pregnancy or disability, or any other basis protected under applicable law. We also make reasonable accommodations for applicants' and employees' religious practices and beliefs, as well as mental health or physical disability needs. Visit our FAQs for more information about requesting an accommodation.