Applications & Data Architect

About Davis Graham & Stubbs

For over a century, Davis Graham & Stubbs LLP (DGS) has ranked among the region's most prominent law firms, consistently offering quality legal services to emerging and established businesses of the Rocky Mountain West. While the firm's Denver location and intermediate size allow a close personal relationship with local and regional clients, our technology and broad experience allow us to partner effectively with businesses and their investors throughout the world. DGS serves clients nationally and internationally, with a strong focus on corporate finance and governance, mergers and acquisitions, natural resources, environmental law, real estate, intellectual property, and complex litigation. Our lawyers have experience working with companies in the energy, mining, technology, hospitality, private equity, manufacturing, asset management, and aviation industries.

Summary

The Applications and Data Architect is responsible for developing custom software solutions, standardizing all aspects of application development and design, in addition to building and maintaining a firmwide data infrastructure model. This position defines policy requirements for data exchange and sharing between different data repositories and high-level architectural specifications, ensuring feasibility, functionality, and integration with existing systems/platforms. May provide consultation on complex projects and is considered to be the top-level contributor.

Essential Functions

• Develop, test, and maintain robust and scalable software applications, including custom solutions, Office Add-ins, SSIS packages, and SPFx web parts

• Creation of custom PowerShell scripts and SQL queries as needed

• Write clean, maintainable, and efficient code

• Troubleshoot, debug, and optimize application performance

• Stay updated with emerging technologies and industry trends to enhance application development practices continually

• Develop high-level and detailed application architecture designs to meet business requirements

• Create applications that are scalable, maintainable, and adhere to best practices and standards

• Collaborate with business analysts and other stakeholders to define and translate application requirements into technical specifications

• Assess and recommend application frameworks, platforms, and tools

• Design, build, and maintain efficient ETL (Extract, Transform, Load) processes to facilitate data integration and transformation

• Optimize data pipelines for performance, reliability, and scalability

• Implement data storage solutions that ensure data availability and security

• Develop and maintain cloud-based data infrastructure

• Design and implement scalable and secure data architectures, including data warehouses, data lakes, and databases

• Develop and enforce data modeling, governance, and data quality standards

• Create and maintain comprehensive data architecture documentation

• Collaborate with business stakeholders to define data requirements and ensure data integrity across all systems

• Evaluate and recommend data management tools and technologies

• Assist in formulating the annual budget and spending within the parameters of the approved budget

• Represent the firm with software vendors and consultants

• Provide technical guidance and coaching to IT engineers

• Other duties as assigned

Required Skills/Abilities

• Extensive experience in application architecture, application engineering, data architecture, and data engineering

• Extensive experience in data management principles, database design, data governance, and quality management

• Extensive experience with the Microsoft development environment (SQL Server, .NET Core, C#, Azure)

• Extensive experience in software development and proficiency in programming languages including C#, React, JavaScript, Typescript, or similar

• Experience with PowerShell, REST, JSON, Power Platform, and Microsoft Dataverse

• Experience with cloud platforms (e.g., Azure, SharePoint Online, Microsoft Graph

• Familiarity with ETL tools and data integration platforms such as Azure Synapse or Azure Data Factory

• Strong analytical, problem-solving, and communication skills

• Ability to work collaboratively in a cross-functional team environment

Supervisory Role

None

Work Environment

This job operates in a remote environment excluding CA, CT, HI, NJ, NY & TX. Because this position will handle client information, employees must work from a home office, not a public location. This role routinely uses standard office equipment such as computers and printers.

Physical Demands

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Prolonged periods working on a computer.

Position Type and Expected Hours of Work

This is a full-time fully remote position based on 40 hours per week with benefits eligibility.

This position will need to be available during the core business hours of M-F 8-5 MST via email, Teams, and phone, with some flexibility in hours due to location or at the manager's discretion. The employee may be required to be at the office at the manager's discretion.

Required Education and Experience

A minimum of 10 years in a developer role working with currently used technological products.

Extensive experience with the Microsoft development environment (SQL Server, .NET Core, C#, Azure)

Preferred Education and Experience

Bachelor's degree in computer science or equivalent

Microsoft Azure Developer Associate (AZ-204)

Other Duties

Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without notice.

Application Deadline

This position is expected to stay open until July 5, 2024 which has been extended from the original deadline of June 21, 2024. Please submit your application as soon as possible and no later than July 5, 2024, at midnight to ensure consideration.

Salary range is based on or commensurate with experience.

DGS offers competitive benefits. For a full list of benefits provided, please select this link: Benefits.

Davis Graham & Stubbs provides equal employment opportunities to all employees and applicants for employment without regard to race, color, religion, gender, sexual orientation, transgender status, gender identity or expression, national origin, age, disability, marital status, genetic information, military status or any other status protected by applicable federal, state or local laws.