Who We Are:
For more than a century, Big Brothers Big Sisters has been helping change kids’ perspectives and giving them the opportunity to reach their potential.
Since 1904, Big Brothers Big Sisters has operated under the belief that inherent in every child is incredible potential. As the nation’s largest donor- and volunteer-supported mentoring network, Big Brothers Big Sisters makes meaningful, monitored matches between adult volunteers (“Bigs”) and children (“Littles”), ages 5 through young adulthood in communities across the country. We develop positive relationships that have a direct and lasting effect on the lives of young people.
Summary of Opportunity:
As a direct report of the Chief Technology Officer, the Senior Data Engineer assists on a wide range of analytics, business intelligence, and data infrastructure/warehouse initiatives designed to support data-driven business strategies. They will be primarily responsible for implementing ETL processes and well-versed in the design and development of ETL and database developments for a large data warehouse, as well as maintaining and supporting production jobs. The Developer will effectively communicate and work collaboratively with other team members, as well as Big Brothers Big Sisters (BBBS) affiliate agency users.
Travel: Less than 5%
Location: Full-time Remote, U.S.
People Manager: No
Essential Duties and Responsibilities
Education & Related Work Experience
Education Level: Bachelor’s Degree required or equivalent combined working experience and education
Years of Related Work Experience: 5+ years' experience designing, developing, testing, and implementing ETL solutions using any enterprise ETL tools (SSIS). 3+ years of experience working with high volume data bases and/or big data. Minimum of 3 years expert level knowledge of Enterprise Server technology areas: SQL Server Analysis Server (SSAS) or SQL Server Integration Services (SSIS).
Skills and Knowledge Extensive knowledge of Data Warehousing and Business Intelligence including various data modeling methodologies and techniques. Experience in gathering and analyzing business and technical requirements. Experience delivering an ETL solution in a Data Warehouse environment as the team lead. Knowledge of the Data Warehouse lifecycle. Experience in SQL Server performance tuning and administration working with large databases (multiple terabytes or larger). Ability to use and explain all aspects of relational database design, multidimensional database design, OLTP, OLAP, KPIs, Scorecards, and Dashboards. Ability to recommend architecture best practices related to ETL, ELT, BI, and the life cycle of an EDW solution. Additional skills will be shared within the full job description if advancing to next steps in recruitment.
At Big Brothers Big Sisters of America, justice, equity, diversity, and inclusion (JEDI) is an integral part of our values and mission. We recognize, affirm, and celebrate the diverse backgrounds, lives, and experiences of all of our stakeholders, including youth, families, donors, volunteers, and staff. We ensure the opportunity for all voices and perspectives to be heard and honored. In the workplace, we foster an environment where all people can be their best selves. We affirm that every person [regardless of ability, age, cultural background, ethnicity, faith, gender, gender identity, gender expression, ideology, income, national origin, race or sexual orientation, marital or veteran status] has the opportunity to reach their full potential. We strive to realize the full potential that is within all of us by ensuring that all voices and perspectives are heard and honored.
Equal Employment Opportunity
BBBSA provides equal employment opportunities to all qualified individuals without regard to race, creed, color, citizenship, religion, national origin, age, sex, familial or marital status, pregnancy, military or veteran status, sexual orientation, gender identity or expression, genetic information, disability, or any other legally protected status in accordance with applicable local, state, and federal laws, regulations, and ordinances.
Americans with Disabilities Act
Employee must be able to perform all essential job functions, with or without reasonable accommodation.
The above statements reflect the general duties, responsibilities and competencies considered necessary to perform the essential duties and responsibilities of the job and should not be considered as a detailed description of all the work requirements of the position. BBBSA may change the specific job duties with or without prior notice based on the needs of the organization.
Big Brothers Big Sisters of America is directly recruiting and hiring for this position. We are not engaging any staffing/recruitment firms or agencies for this position. If any candidate profile/resume/identifying information is sent to Big Brothers Big Sisters of America and/or Big Brothers Big Sisters agencies, we will not pay any referral or firm fees in relation to this information.