Data Engineer (Mid to Sr Level) at Vaco, LLC
San Diego, CA 92131
About the Job
*
Job Description
Are you passionate about designing, developing, testing and deploying data reporting and systems? Do you like to work collaboratively with other programmers, departments and stakeholders to manage deployments?
Do you like to develop functional software and to keep up with current trends and issues in data engineering? If this sounds interesting to you, below are a few more details.
- Designs and develops SQL Server databases for internal processes. Works on complex schema design (relationships, data modeling, normalization). Develops highly efficient triggers, stored procedures, functions, and views needed for system and reporting functionality. Loads and maintains system meta data.
- Develops reporting solutions for Enterprise Data Warehouse (EDW) and other internal systems with SQL Server Reporting Services and Power BI. Creates reports and dashboards that are easily understood by end business users.
- Develops code required to extract data from source systems and populate our Enterprise Data Warehouse (EDW). Works with data definitions, transformation rules, data manipulation language (DML), and BI data models to design and load data from source systems to target tables. Tests and validates accuracy of loads.
- Assists with providing technical direction for modernizing our Data and Analytics systems in the cloud. Has knowledge of Microsoft’s Azure services used for Data and Analytics. Experienced in moving processes and refactoring them to Azure using services such as Azure Data Factory, Databricks, Data Lake Storage, Synapse, SQL, Apache Spark, and Fabric.
- Provides administrative and maintenance support for Enterprise Data and Analytics systems, other SQL Server databases, web servers, and BI systems. Resolves performance and data availability issues with production systems. Manages, maintains, and ensures availability of solutions for business users.
- Creates data extracts from vendor systems to feed other internal systems. Creates data extracts from internal systems for vendor needs to support operational items or analysis.
- Develops software that is functional and designed to user and/or department specifications and requirements. Works with other departments on project development. Attends meetings with appropriate employees or vendors to obtain necessary information and direction to proceed with the development and success of the project.
- Guides programmers by providing direction on projects and assistance with questions. Assists with staff code reviews for changes to our Enterprise Data and Analytics systems. Ensures overall quality of code and ensures code meets best practices in design and standards.
- Keeps current with trends and issues in the domains of data engineering, BI development, data science, decision intelligence, cloud computing, including operational best practices.
- Resolves emergency system problems, including assistance with weekend and off-hours support. Recognizes errors and/or problems that require time sensitive research and resolution. Integrates findings for identifying and resolving similar future problems in a timely and accurate manner.
- Assists with department source control management (SCM) and software development life cycle (SDLC) processes. This includes Azure DevOps (ADO) merges, builds, and deployments assistance and oversight. Adheres to internal procedures and SDLC standards, including change management protocols.
- Documents new processes. Updates existing documentation as needed based on coding changes being made. Adheres to internal coding and SDLC standards, including change management protocols.
- Maintains in depth knowledge of and complies with all Mission Fed, departmental and security policies and procedures, as well as, federal regulations applicable to the position, including BSA requirements. Completes all required compliance training as assigned.
- Performs other duties as assigned.
Here is what we are looking for:
- Bachelor’s Degree in Computer/Software Development, Information Technology or related discipline is required. Two years of equivalent experience can substitute for every one year of education.
- A minimum 5 years of database engineering and design in an online analytical processing environment (OLAP) and online transaction processing environment (OLTP) in both on-premise and Azure, 5 years of experience in developing code with SQL Server Integration Services (SSIS), Python, or Azure Data Factory (ADF) to extract, transform, and load data into data warehouses, and 5 years of experience in developing enterprise reporting solutions with SQL Server Reporting Services (SSRS) and Power BI is required. Must have expert knowledge of SQL Server versions 2016 and above and must understand data warehouse concepts such as dimensional designs, star schemas, data modeling, historical and incremental data modeling, data quality, extract, transform and load (ETL), and Query & Reporting. Experience with Agile and Scrum development methodologies.
What we offer:
- One of San Diego and the nation's Top Workplaces three years running!
- Great team and company culture!
- You can’t beat a role in sunny San Diego!
- 18 days of PTO in your first year plus 12 holidays a year!
- 6% - 8% 401(k) match
- Full benefits package including medical, dental, vision, life insurance, etc.
If this sounds like an amazing opportunity to you (because ya, it is!), we want to hear from you!
Base Pay/Salary: $93,000 - $130,000 per year
The salary range that we expect to pay for this position is $93,000 - $130,000. Actual base pay within this range will be determined by several components, including but not limited to, relevant experience, internal equity, skills, qualifications, and other job-related factors permitted by law.
Your privacy is very important to Mission Federal Credit Union. The California Consumer Privacy Act (“CCPA”)/ California Privacy Rights Act (CPRA) requires Mission Federal Credit Union to inform California residents, including job applicants, of the categories of personal information we collect and the purpose for which the personal information will be used. This job applicant notice and the CCPA/CPRA notice provides the disclosures required by the CCPA/CPRA and applies only to applicants who are subject to the CCPA/CPRA.
Mission Federal Credit Union is an Equal Opportunity Employer. All applicants will receive consideration without regard to race, sex, color, creed, religion, age, marital status, sexual orientation, national origin, physical or mental disability, veteran status, or any other class protected by law. INDMF
Vaco values a diverse workplace and strongly encourages women, people of color, LGBTQ+ individuals, people with disabilities, members of ethnic minorities, foreign-born residents, and veterans to apply.
EEO Notice
Vaco is an Equal Opportunity Employer and does not discriminate against any employee or applicant for employment because of race (including but not limited to traits historically associated with race such as hair texture and hair style), color, sex (includes pregnancy or related conditions), religion or creed, national origin, citizenship, age, disability, status as a veteran, union membership, ethnicity, gender, gender identity, gender expression, sexual orientation, marital status, political affiliation, or any other protected characteristics as required by federal, state or local law.
Vaco LLC and its parents, affiliates, and subsidiaries are committed to the full inclusion of all qualified individuals. As part of this commitment, Vaco LLC and its parents, affiliates, and subsidiaries will ensure that persons with disabilities are provided reasonable accommodations. If reasonable accommodation is needed to participate in the job application or interview process, to perform essential job functions, and/or to receive other benefits and privileges of employment, please contact HR@vaco.com .
Vaco also wants all applicants to know their rights that workplace discrimination is illegal.
By submitting to this position, you agree that you will be giving Vaco the exclusive right to present your as a candidate for the foregoing employment opportunity. You further agree that you have represented information about yourself accurately and have not affirmatively misrepresented your qualifications. You also agree to maintain as confidential, to the fullest extent permitted by law, any information you learn from Vaco about the position and you will limit disclosure of information about the position only to the extent necessary to perform any obligations in furtherance of your application. In exchange, Vaco agrees to exercise reasonable efforts to represent you through all solicitation, job screening and resume dispersal.
Privacy Notice
Vaco LLC and its parents, affiliates, and subsidiaries (“we,” “our,” or “Vaco”) respects your privacy and are committed to providing transparent notice of our policies.
- California residents may access Vaco’s HR Notice at Collection for California Applicants and Employees here.
- Virginia residents may access our state specific policies here.
- Residents of all other states may access our policies here.
- Canadian residents may access our policies in English here and in French here.
- Residents of countries governed by GDPR may access our policies here.
Pay Transparency Notice
Determining compensation for this role (and others) at Vaco depends upon a wide array of factors including but not limited to:
- the individual’s skill sets, experience and training;
- licensure and certification requirements;
- office location and other geographic considerations;
- other business and organizational needs.
With that said, as required by local law, Vaco believes that the following salary range referenced above reasonably estimates the base compensation for an individual hired into this position in geographies that require salary range disclosure. The individual may also be eligible for discretionary bonuses.