Job description
Overview:
We're a spirited team that believes in having fun and making an impact in our community and beyond. Beech Acres offers competitive salaries, generous paid time off, and a comprehensive training program to support you in your journey. We’ve built a culture that values each employees unique strengths and is welcoming and inclusive for all. We’ve recently implemented an exciting new strategic vision for the organization that will guide us through the next three years and beyond. Come be part of positive change happening in schools, pediatric offices, workplaces, the community, and the world. Responsibilities:
A typical day will include:
BAPC provides equal employment opportunities (“EEO”) to all persons, consistent with applicable federal, state and local equal employment opportunity laws prohibiting discrimination based on race, sex, pregnancy, sexual orientation, gender identity, age, disability, genetic information, religion, ancestry, military or veteran status, color, national origin, or any other applicable statutorily protected group status under local, state, or federal law. This applies to all phases of the employment relationship including recruitment, hiring, compensation, advancement, and discipline.
At Beech Acres Parenting Center, we uncover the natural gifts of children by unleashing the power of parents and caregivers. As a contemporary parenting center, Beech Acres serves over 30,000 people annually through a wide range of services including foster care, kinship care, adoption, behavioral health support in schools, parent coaching and much more. All of our programs are founded in our Natural Strength Parenting™ framework which enables parents to unlock their own potential by building on their unique strengths. For more information, visit www.beechacres.org
We're a spirited team that believes in having fun and making an impact in our community and beyond. Beech Acres offers competitive salaries, generous paid time off, and a comprehensive training program to support you in your journey. We’ve built a culture that values each employees unique strengths and is welcoming and inclusive for all. We’ve recently implemented an exciting new strategic vision for the organization that will guide us through the next three years and beyond. Come be part of positive change happening in schools, pediatric offices, workplaces, the community, and the world.
Beech Acres Parenting Center (“The Beech” as we like to call it!) is looking to add an experienced Sr. SQL Developer who is passionate about gathering and preparing data to support our mission to serve the developmental needs of children and the skills and wellbeing of their caregivers. This will involve SQL development using a wide range of T-SQL coding skills, strategies, and techniques to produce the data sets used by our internal software applications, SQL Server Reporting Services, and by staff members as needed on an ad-hoc basis. This role will also support all data facets of the agency enterprise data warehouse, from ETL and Integration development to end user query development. Finally, this role will perform database administrative tasks and user application support as needed.
A typical day will include:
- Develop and maintain complex T-SQL queries, stored procedures, and user-defined functions.
- EDI Development – working with third party API interfaces to extract data from remote systems.
- Assist in custom SQL development to provide enhancements to agency’s core applications.
- Develop custom SQL scripts to provide solutions for specific agency data needs and/or challenges.
- Develop and maintain ETL data flows to support agency data warehouse.
- Understand dimensional modeling fundamentals as needed to develop efficient data warehouse queries.
- Develop and maintain SSRS reports as needed to support various business areas.
- Monitor nightly database backups and general database health.
- Manage database security as needed.
- Work closely with agency staff to understand business processes and data requirements that will aid in the delivery of information (automated when possible) to support our staff in making data-driven/informed decisions.
- Monitor incoming reporting requests and assist with application/admin support.
- This can be a hybrid position after training is completed.
- Bachelor’s Degree in Computer Science or Information Technology, or equivalent experience and/or certifications.
- 5+ years of SQL experience
- Strong T-SQL skills required, with 2+ years of T-SQL experience preferred.
- Understanding of SQL Server Relational Database objects and concepts, including schemas, tables (physical, temporary, and derived), views, indexes, stored procedures, UDF types, triggers, and DB links.
- Understanding of data warehouse concepts, including dimensional data modeling/architecture, dimensional data conformance and integration, and complex ETL processes supporting slowly changing dimensions.
- Familiarity with DBA activities, including backup and restore procedures, security management, database file management, consistency checks, and index maintenance.
- Microsoft SQL Server Certification (2008 R2 or higher) is a plus.
- A background check is required for this position.
- A passion for our mission!
Beech Acres is an Equal Opportunity Employer
BAPC provides equal employment opportunities (“EEO”) to all persons, consistent with applicable federal, state and local equal employment opportunity laws prohibiting discrimination based on race, sex, pregnancy, sexual orientation, gender identity, age, disability, genetic information, religion, ancestry, military or veteran status, color, national origin, or any other applicable statutorily protected group status under local, state, or federal law. This applies to all phases of the employment relationship including recruitment, hiring, compensation, advancement, and discipline.
jackharris.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, jackharris.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, jackharris.com is the ideal place to find your next job.