Data Integrity Analyst

Squarespace New York , NY 10007

Posted 4 months ago

Data Integrity Analyst

Squarespace is looking for Data Integrity Analyst to join the newly created Data Integrity organization. As a member of this new organization you will be engaging with business and technology SMEs in creating and executing procedures leading to improving our overall data handling and assuring that data is fit for purpose. In your day-to-day, you'll be working closely with data engineers and data scientists, as well as Finance and Compliance, Marketing and Product Leads.

You'll be reporting to Data Integrity Lead. Position is located in New York City.


  • Lead creation and management of company wide Data Dictionary

  • Identify and train business and technical partners: Data Owners and Stewards

  • Analyze data related business and technical needs, elicit and document requirements related to data integration from source systems to target data warehouse capabilities (i.e. ETL tools, ODS, EDW, etc.), data marts, data analytics tools and information delivery solutions

  • Document business and technical requirements related to data mapping and ETL requirements and related data lineage and requirements traceability

  • Define test cases and scripts that correspond to business requirements along with test planning and execution support

  • Partner with the Data Architect, responsible for building a formal description of the data and data structures, including data definitions, data models, data flow diagrams

  • Develop and enforce methods and validation mechanisms for ensuring data quality

  • Identify causes of poor data quality, implement solutions and communicate findings.

  • Identify and ensure the resolution of data quality issues, such as uniqueness, consistency, and completeness in a cost-effective and timely fashion.


  • Relevant experience as a business analyst for technical projects

  • Hands-on Data Analysis skills using SQL.

  • Understanding of business intelligence / data warehousing technologies

  • Preferably strong knowledge data models/modeling and ability to apply models to newly developed data warehouse and related tools and processes

  • Excellent verbal and written communication skills, capable of presenting complex issues in a clear, concise and persuasive manner to business and technical professionals.


  • Health insurance with 100% premium covered

  • Flexible vacation & paid time off

  • Up to 18 weeks of parental leave

  • Equity plan

  • 401(k) plan with employer match

  • Free lunch and snacks

  • Squarespace sends engineers to speak at and attend the most relevant and impactful conferences throughout the year

  • Dog-friendly workplace

  • Education reimbursement


Squarespace makes beautiful products to help people with creative ideas succeed. By blending elegant design and sophisticated engineering, we empower millions of people from individuals and local artists to entrepreneurs shaping the world's most iconic businesses to share their stories with the world. Squarespace's team of more than 800 is headquartered in downtown New York City, with offices in Dublin and Portland. For more information, visit

Today, more than a million people around the globe use Squarespace to share different perspectives and experiences with the world. Not only do we embrace and celebrate the diversity of our customer base, but we also strive for the same in our employees. At Squarespace, we are committed to equal employment opportunity regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, gender, gender identity or expression, or veteran status. We are proud to be an equal opportunity workplace.

See if you are a match!

See how well your resume matches up to this job - upload your resume now.

Find your dream job anywhere
with the LiveCareer app.
Download the
LiveCareer app and find
your dream job anywhere

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Program Integrity Data Analyst

Deloitte & Touche L.L.P.

Posted 2 weeks ago

VIEW JOBS 12/5/2018 12:00:00 AM 2019-03-05T00:00 Are you an analytical, data-driven professional? Are you interested in a role that uses leading edge analytics and offers an opportunity to provide front line support to solve our clients' most challenging problems associated with health care Payment Integrity / Fraud, Waste and Abuse detection and prevention? If so, the Forensic Analytics practice is the place for you! Data analysts apply their specialized knowledge of data acquisition, management, analysis, and interpretation directly to healthcare data, providing actionable insights that Deloitte, our clients, decision-makers, and others can use. It's a great career choice for those who want to apply healthcare expertise in a novel and innovative way. Forensic Analytics is a fast-growth practice within Deloitte Risk and Financial Advisory that centers around several of the hottest areas of business today – analytics, forensic analysis, and litigation support – and the specialized skills that make careers in these areas both fascinating and in high-demand. Our Analytics team makes extensive use of data, statistical and quantitative analysis, rules-based methods, and explanatory and predictive modeling to bring insights to client issues. Our work increasingly employs specialized competencies, such as advanced analytics, visualization, and geospatial techniques. Work you'll do * Query and mine large health care related data sets to discover transaction patterns, examine financial data and filter for targeted information * Gather and interpret data from a variety of sources (e.g., claims, eligibility, contract /pricing, cost reports) and critically evaluate it, reconcile conflicts, disseminate high-level information into details and distinguishing user requests from their true needs * Create, manage, analyze and utilize high performance relational databases (e.g., SQL Server, Oracle, Microsoft Access, OLAP and other proprietary software) * Query and mine large data sets to discover transaction patterns, examine financial data and filter for targeted information * Design and develop models and solutions that use predictive analytics, text analytics and cognitive computing, and big data frameworks, in order to find anomalies and hidden patterns * Develop dashboards to visualize and integrate data from across the globe * Provide assistance interpreting needs of customers and translating them into the application and operational requirement with the help of product management skill * Liaison between technology teams, support teams and business teams * Assist in preparing and presenting complex written and verbal materials (reports, findings and presentations) * Review deliverables for accuracy and quality * Provide coaching to junior staff * Contribute to new business proposals and proposal development * Manage own personal and professional development; seek opportunities for professional growth and expansion of consulting skills and experience The team As a member of our Forensic Analytics practice in the Senior Consultant role, you will work on projects that will allow you to collaborate with clients, and other analysts and investigators. As part of these projects, you'll be provided the opportunity to demonstrate your technical, project management and leadership skills in an environment that provides for outstanding growth and advancement. Position may necessitate intermittent travel and requires flexibility with the client service projects. Qualifications Minimum Qualifications: * Bachelor's Degree in Economics, Finance, Statistics, Mathematics, Computer Science, Management Information Systems, Engineering, Business Analytics disciplines, or related area * Experience with Health care data analytics * 3+ years of hands-on technical experience mining and analyzing transactional electronic data with competency in a variety of analytics tools and programming languages such as, but not limited to: * Microsoft SQL Server, Oracle, Mongo Db * Predictive Analytics/Data Mining: (e.g., IBM SPSS, SAS Enterprise Miner, RPL, Python, Matlab) Data Visualization Tools (e.g. QlikView, Tableau, Power Bi) * Big Data Tools (e.g., Hadoop, Hive, Pig, Impala, Mahout) * Reporting Tools (e.g., Business Objects, Reporting Services) Financial Tools (e.g. NumeriX, Bloomberg, FinCad, Monte Carlo simulation tools * Languages (e.g., SQL, Java, JavaScript, jQuery, AJAX, C#, C++, VBA, VB.Net, ASP.Net, HTML, SAS) * Proficiency in word processing, spreadsheet, and presentation creation tools, as well as Internet research tools * Professional demeanor and strong communication skills, both written and oral * Demonstrated problem solving and troubleshooting skills with experience exercising mature judgment * Ability to work independently and manage multiple projects and responsibilities in a fast-paced environment * Proven experience effectively prioritizing workload to meet deadlines and work objectives * Travel up to 50% may be required, depending on role and location Preferred Qualifications * Experience working in Payment Integrity / FWA detection and prevention space is a plus * Previous accounting/audit or analytics experience in a professional services firm * Master's Degree in Economics, Finance, Statistics, Mathematics, Computer Science, Management Information Systems, Engineering or a professional affiliation such as CPA, FCPA, CFE, MBA, ASA, and/or CFA How you'll grow At Deloitte, our professional development plan focuses on helping people at every level of their career to identify and use their strengths to do their best work every day. From entry-level employees to senior leaders, we believe there's always room to learn. We offer opportunities to help sharpen skills in addition to hands-on experience in the global, fast-changing business world. From on-the-job learning experiences to formal development programs at Deloitte University, our professionals have a variety of opportunities to continue to grow throughout their career. Explore Deloitte University, The Leadership Center. Benefits At Deloitte, we know that great people make a great organization. We value our people and offer employees a broad range of benefits. Learn more about what working at Deloitte can mean for you. Deloitte's culture Our positive and supportive culture encourages our people to do their best work every day. We celebrate individuals by recognizing their uniqueness and offering them the flexibility to make daily choices that can help them to be healthy, centered, confident, and aware. We offer well-being programs and are continuously looking for new ways to maintain a culture where our people excel and lead healthy, happy lives. Learn more about Life at Deloitte. Corporate citizenship Deloitte is led by a purpose: to make an impact that matters. This purpose defines who we are and extends to relationships with our clients, our people and our communities. We believe that business has the power to inspire and transform. We focus on education, giving, skill-based volunteerism, and leadership to help drive positive social impact in our communities. Learn more about Deloitte's impact on the world. Recruiter tips We want job seekers exploring opportunities at Deloitte to feel prepared and confident. To help you with your interview, we suggest that you do your research: know some background about the organization and the business area you're applying to. Check out recruiting tips from Deloitte professionals. As used in this document, "Deloitte" means Deloitte LLP and its subsidiaries. Please see for a detailed description of the legal structure of Deloitte LLP and its subsidiaries. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability or protected veteran status, or any other legally protected basis, in accordance with applicable law. Deloitte will consider for employment all qualified applicants, including those with criminal histories, in a manner consistent with the requirements of applicable state and local laws. See notices of various ban-the-box laws where available. Requisition code: E19NATESRCLH01-PI Deloitte & Touche L.L.P. New York NY

Data Integrity Analyst