Job Title:

Senior ETL/Data Analyst

Job Type:

Contract (also open to Contract-to-Hire), with an initial project duration of approximately 3 months. We are looking for someone who can start within the next several days.

Brief Job Description:  

LiteracyPro creates software for social good. Our data collection and reporting software helps government and community-based organizations help hundreds of thousands of disadvantaged people improve their opportunities to get jobs with sustainable, living wages for themselves and their families. Enjoy being part of a fun group of bright, passionate folks, in a great working environment, with generous salary & benefits while helping those who help others.

Our newest product, CommunityPro Suite (CPS), is a growing SaaS case management, referral, reporting and analysis enterprise application that enables hundreds of agencies to securely match, consolidate and share data in real time. The purpose of the software is to reduce organizational friction by helping local agencies better collaborate to help people achieve economic self-sufficiency for themselves and their families. The end-goal of CPS is to play an important role in helping to create healthy, vibrant communities in this country and the world.

Our Company is experiencing explosive growth due to increasing national demand for our software, and we’re looking for that rare, accomplished data analyst who wants to do good, get paid well and have fun doing it. We’re seeking someone with an energizing leadership style, and who has the smarts, passion and people skills to guide our efforts on all aspects of the data management process, including: on-boarding; acquisition; attribution; transformation; and reporting of newly acquired data sets to provide high-quality data supporting analytics and our clients’ needs in a timely fashion.

Given the highly execution-focused nature of the work, the ideal candidate will roll up their sleeves to ensure that their projects meet deadlines and will always look for ways to optimize processes in future cycles.

Responsibilities:

This position has the primary responsibility for the acquisition, transformation, and maintenance of data for our primary SaaS application. This data is interchanged from and returned to an increasingly diverse set of third-party source systems.

• Conduct in-depth data profiling and data quality assessments of data received from multiple source systems to determine the current level of data accuracy, conformation to standards, reporting requirements, etc.
• Investigate data flow issues by discovering system states that prevent successful job completion (source systems, infrastructure, etc.).
• Identify and analyze the errors/inconsistencies in the data; provide timely resolutions for data lineage and data cleansing.
• Build and validate a data quality framework with alerts for data discrepancies.
• Work with the product owner/system owner, development, and QA teams to ensure alignment and proper interpretation of complex data requirements.
• Develop technical documentation, including requirements documents, process overviews, data models, data flow, and ETL jobs.

Experience and Qualifications:

• 6+ years performing analysis and building data processes.
• 6+ years of experience with ETL tasks such as reviewing business requirements, developing and troubleshooting data cleansing and loading solutions, preparing solution documentation, data dictionaries, metadata repositories, and database security.
• 6+ years of industry experience with the development and implementation of enterprise-level data warehousing and supporting business intelligence initiatives, particularly focused on star schema data modeling.
• 6+ years of experience with database design, including mastery of complex report queries and SQL optimization.
• Experience with MySQL, Amazon Web Services, Microsoft Azure. Experience with Pentaho CE a plus!
• Familiarity with the data security and privacy requirements of FERPA, HIPPA, SOC2 and related industry and legal standards

• Degree in Computer Science, Information Systems, Mathematics, or equivalent quantitative field

Our Mission

“To be a powerful force of good in the world by creating revolutionary tools for those serving humanity.”

Our Culture

• Aptitude to thrive in a pioneering environment and successfully manage multiple priorities and projects with critical deadlines.
• Insanely curious, naturally approaches challenges with energy and positivity. 
• Your word is your bond. Your sincerity and honesty easily generate a deep sense of admiration and loyalty in your team.
• You’re an exceptional listener; you ask lots of questions to better understand complex problems and interpersonal matters.
• You can laugh at yourself; you’re only human and make mistakes like the rest of us.

Our Core Values:

The very core of LiteracyPro Systems is our genuine belief in, and adherence to, the company’s six core values:

• Honesty and ethical behavior above all else
• Teamwork—we sink or swim together
• Work hard, have fun
• Passion for excellence—second best will never suffice
• We follow through on our commitments—we mean what we say and we say what we mean
• Service to our community

These six core values guide us in everything we do—from the commitments we make and the execution of our business plan, to the way we treat each other on a daily basis. Our values foster a deep sense of responsibility to our customers, vendors, and investors as well as to fellow team members. We are driven by the satisfaction of excellence.

Salary:

Full-time; $75/hour - $95/hour