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

Develops, designs, tunes, and maintains SSIS packages to perform ETL processes.
Designs and develops SQL Server stored procedures, functions, views, and triggers to be used during the ETL process.
Designs and develops ETL solutions using data integration tools for interfacing between source application and the Enterprise Data Warehouse.
Develops ETL technical specifications, designs, develops, tests, implements, and supports optimal data solutions.
Documents data mappings, data dictionaries, processes, programs, ETL jobs and solutions as per established standards for data governance.
Integrates ETL development with existing projects to maximize object reuse
Creates, executes, and documents unit test plans for ETL and data integration processes and programs.
Performs problem assessment, resolution, and documentation in existing ETL packages, mapping and workflows in production.
Troubleshoots data issues and defects to determine root causes in a timely manner.
Conducts performance tuning of the ETL process and SQL queries and recommend and implement ETL and query tuning techniques.
Develops and creates transformation queries, views, and stored procedures for ETL processes, and process automations.
Meets with shareholders to understand business needs for data automation and creates user specs for team development
Creates documentation and delivers trainings on donor management and reporting needs
Creates UAT plans, identifies UAT resources from other departments, trains staff on how to UAT and log bugs
Creates secure, accessible, custom Power BI dashboards for users using DAX code and tabular data modeling
Architects Salesforce solutions to prevent row blocking and CPU timeouts for both batch jobs and User manually inserted or updated records
Consults team and helps to implements relational Salesforce data structures to accommodate ease in reporting
Works closely with third party consultants to not only train their external developers on our business needs but to ensure the solution to be achieved is sustainable and scalable for the IT team
Monitors Salesforce database backups and SQL Data Warehouse backups
Performs scripted data subset migrations from one Agency to another when mergers and acquisitions occur
Assists with report Case management and customer service for Power BI Users
Maintains Azure environments and assures patches and upgrades are installed regularly to prevent data security vulnerabilities
Other duties as assigned.

Culture

Demonstrates a commitment to cultural diversity and inclusion that reflects BBBSA’s commitment to JEDI (justice, equity, diversity, and inclusion).
Champions internal and external culture of the organization focusing on being a JEDI-focused youth empowerment and equity organization.
Provides consistent follow-up regarding assigned projects and after meetings.
Manages related and other duties as assigned in support of department and business needs.

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.

JEDI Commitment

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.

Job Responsibilities

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.