Enterprise Data & Analytics Architect

Key Details:

• Direct Hire/Perm
• Location: Scripps Ranch, San Diego - Hybrid (3 days onsite, 2 days remote)
• Salary: $130-150k + 8% bonus (avg)
• Must be eligible to work in the US without sponsorship now or in the future.

Summary:

The Data Architect assists the Enterprise Data & Analytics management team with oversight of the Data Engineering, Data Science, and Reporting/BI Developers and is responsible for providing leadership on design, standards, scalability, security, performance, and the overall technological direction of the department. Assists management with staff mentorship and training. Assists management with project discovery and requirements gathering. The data architect is a technical lead in the department that oversees the code review process, build management, and deployments to production systems. The data architect oversees systems support and troubleshooting.

Responsibilities:

1. Provides a strong technical direction for our Enterprise Data and Analytics systems. Has expert knowledge in Microsoft's technical stack including SQL Server, SSIS/ADF, SSRS, and Power Platform including Power BI and uses that knowledge to manage the technical quality of the development team and for organizational project deliverables.
2. Provides a strong technical direction for modernizing our Data and Analytics systems in the cloud. Has expert knowledge in Microsoft's Azure services used for Data and Analytics. Experienced in moving processes and refactoring them to Azure tools such as Azure Data Factory, Data Lake/Lakehouse architectures, and platforms like Microsoft Fabric or Snowflake.
3. Assists management with staff mentorship, coaching, and training.
4. Leads the development effort on many Enterprise Data & Analytics project requests. Assists with project discovery and requirements gathering (scope development). Assists with project planning, delegation of tasks, and resource allocation. Guides developers by providing direction on projects and assistance with questions.
5. Lead resource on 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.
6. Leads department source control management (SCM) and software development life cycle (SDLC) processes. This includes Azure DevOps (ADO) merges, builds, and deployments assistance and oversight. Ensures adherence to internal procedures and SDLC standards, including change management protocols.
7. 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.
8. 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.
9. Oversees the department's system and process documentation. Ensures new processes are documented. Updates existing documentation as needed based on coding changes being made.
10. Keeps current with trends and issues in the domains of data engineering, BI development, data science, decision intelligence, cloud computing, including operational best practices.
11. Designs and develops SQL Server databases for internal processes. Works on complex schema design (relationships, data modeling, dimension modeling, normalization). Develops highly efficient triggers, stored procedures, functions, and views needed for system and reporting functionality. Loads and maintains system meta data.
12. 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.
13. Develops reporting solutions for Enterprise Data Warehouse (EDW) and other internal systems with SQL Server Reporting Services (SSRS) and Power BI. Creates reports and dashboards that are easily understood by end business users.
14. Helps with oversight of development of web applications and windows programs using the industry standard Software Development Life Cycle with C#, .NET, Power Platform, or other web technologies. Helps with oversight of development of Data Science models built in Python or R.
15. Maintains in-depth knowledge of and complies with all company, 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.
16. Performs other duties as assigned.

Qualifications:

• Education: 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.
• Experience:
  • A minimum 8-10 years of database engineering and design in an online analytical processing environment (OLAP) and online transaction processing environment (OLTP), 8 years of experience in developing code with SQL Server Integration Services (SSIS) or Azure Data Factory (ADF) to extract, transform, and load data into data warehouses, and 8 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 experience moving processes and refactoring them to Azure.
  • Experience with Agile and Scrum development methodologies.
  • Familiarity with web application and data science development is a plus.
  • Familiarity with Python and PowerShell is a plus.

Competencies:

• Skills & Abilities: The ideal candidate will be self-directed and self-motivated, have strong attention to detail and organizational skills. Must have problem recognition, solving and resolution, and be multi-task oriented. Strong oral and written communications skills are required. Ability to lead and mentor other developers.
• Software: Microsoft Office Suite (Word, Excel, Visio), Microsoft SQL Server, SSRS, SSAS, SSIS, and Power Platform including Power BI and Power Query. Microsoft Cloud Technologies including Azure Data Factory (ADF), Databricks, Data Lake/Lakehouse architectures, and Fabric or Snowflake.
• Software (other): Crystal Reports and SCM systems Microsoft Team Foundation Server (TFS), GIT, and Azure DevOps (ADO). Familiarity with CI/CD pipelines is a plus.

All qualified applicants will receive consideration for employment without regard to race, color, national origin, age, ancestry, religion, sex, sexual orientation, gender identity, gender expression, marital status, disability, medical condition, genetic information, pregnancy, or military or veteran status. We consider all qualified applicants, including those with criminal histories, in a manner consistent with state and local laws, including the California Fair Chance Act, City of Los Angeles' Fair Chance Initiative for Hiring Ordinance, and Los Angeles County Fair Chance Ordinance.