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 rep

    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.