Data Analyst
About The Position
Knights of Columbus is seeking a Data Analyst to join its Data Analytics Center of Excellence. The role supports data integration, data profiling, and data-driven decision-making across business units, aligned with organizational brand strategy and priorities. The Data Analyst identifies, builds, and maintains analytics solutions for business users and works with business partners and other analysts to deliver complex analytical outcomes. The role involves collaborating with business leaders to understand objectives and developing analytics solutions that support market expansion and growth in membership, sales, investments, and charitable giving. The analyst works with business stakeholders and teams across IT, IT Security, Data Warehouse, vendors, and contractors, and communicates project insights, issues, and decisions clearly. The position requires U.S. work authorization and is not eligible for visa sponsorship. The stated compensation range applies to work performed in Connecticut; the employer may adjust the range for other work locations.
Requirements
- Bachelor of Arts or Bachelor of Science degree emphasizing Business, Statistics, Analytics, or Marketing, or equivalent professional experience.
- 3 to 5 years of data analysis or data engineering experience supporting data building and analysis for business units.
- Record of business process improvement using data.
- Strong SQL programming skills.
- Experience with the Snowflake ecosystem.
- Experience with Data Vault 2.0 and dimensional modeling.
- Familiarity with Data Lake House and Medallion architecture.
- Proficiency in several areas of data modeling, statistical analysis, data engineering, and data visualization.
- Experience with databases and similar applications.
- Ability to analyze, interpret, and present data using industry-relevant software.
- Effective oral and written communication skills, including the ability to explain complex analysis and insights simply.
- Ability to communicate technical matters with businesspeople and business matters with technical people.
- Ability to identify previously uncovered business-improvement analysis using new data sets.
- Ability to analyze information to identify trends or diagnose problem areas.
- Sound judgment and ownership of gathered data, including the ability to make informed, critical decisions quickly.
- Understanding of cloud-based application architectures.
- Expert understanding of project management.
- Excellent interpersonal, analytical, and problem-solving skills.
- Ability to relate well to others, engage people, support understanding of change, seek and provide feedback, communicate clearly, and listen actively.
- Teamwork skills and ability to work in complex cross-functional settings.
- Comfort working in a constantly changing environment with competing projects and priorities, complexity, and ambiguity.
- Understanding of change management principles.
- Ability to gather data, compile information, and prepare reports.
- Authorization to work in the United States.
Nice To Haves
- Master’s degree in Business, Statistics, Computer Science, or Marketing.
Responsibilities
- Collaborate with business leaders to understand business goals and develop analytics solutions to support market expansion and growth in membership, sales, investments, and charitable giving.
- Develop detailed source-to-target mappings to support engineering integrations.
- Write complex analytical queries for proofs of concept, data modeling, and data profiling.
- Develop data validation and quality assurance test cases for data integration pipelines.
- Identify and enhance valuable internal and external data sources by enriching existing data with third-party sources.
- Communicate insights through data visualizations, dashboards, and reports for internal and external use.
- Collaborate with department managers, IT, IT Security, Data Warehouse, vendors, and contractors regarding enterprise and departmental data needs.
- Stay current on relevant analytical trends, practices, technologies, and solutions and support their timely introduction where appropriate.
- Meet with stakeholders and communicate project issues and decisions clearly and transparently.
- Perform other related duties as assigned.
Benefits
- 13 paid holidays per year, in addition to vacation and paid sick leave.
- Flexible workweek schedules.
- Certifications, designation, and tuition reimbursement.
- 401(k) retirement savings plan with matching company contributions.
- Cash balance retirement plans fully funded by the company.
- Short-term disability and term life insurance fully paid for by the company.
- Up to 12 weeks of childbirth leave under the short-term disability policy.
- One week of fully paid parental leave for all new parents, including adoptive and foster parents.
- Health insurance options, including premium-level family coverage and a pre-tax Health Savings Account with employer contributions.
- Long-term disability insurance.
- Dental insurance.
- Vision insurance.
- Health club membership reimbursement.
- Employee Assistance Program.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
