U.S. LawShield®
1 day ago Be among the first 25 applicants
Get AI-powered advice on this job and more exclusive features.
At U.S. LawShield our focus is on encouraging people to take proactive measures to improve their safety and self-defense abilities—and to serve those who do. We strive to create better-protected communities of responsible self-defenders who have the peace of mind to live their lives confidently. Our company was established in 2009. After initially launching in Texas as Texas LawShield, the demand for services developed well beyond state lines. Our coverage began to expand across the United States, which is when we became U.S. LawShield.
Today, we provide coverage in 46 states and have proudly served more than 2 million people in their self-defense journey. Ready to join our driven and talented individuals who care about protecting the rights of responsible self-defenders?
We are seeking a highly experienced and analytical Data Analytics Architect with a proven track record in designing, building, and optimizing databases and data warehouses. The ideal candidate will have 10–15 years of hands-on experience in data management, analytics, and reporting, with a strong preference for expertise in Microsoft-based toolsets and technologies. This individual will work closely with business leaders to identify key business indicators, normalize and integrate data from disparate sources, and deliver actionable insights through advanced reporting solutions.
Key Responsibilities
Database and Data Warehouse Architecture:
O Design, build, and maintain robust databases and data warehouse architectures optimized for analytics and reporting.
Ensure scalability, security, and performance across all data storage solutions. Manage schema design, indexing strategies, and ETL (Extract, Transform, Load) processes using best practices.
Data Integration and Normalization:
Analyze and understand data from multiple heterogeneous sources (e.g., ERP, CRM, transactional, third-party). Develop and implement normalization frameworks to standardize data structures for reporting and analytics. Create data pipelines that ensure data quality, integrity, and consistency across the business.
Analytics and Reporting:
Leverage Microsoft analytics tools (such as SQL Server, Power BI, Azure Synapse Analytics, SSIS, SSRS, and SSAS) to deliver dynamic reporting and visualizations. Collaborate with business stakeholders to identify and define key business indicators (KBIs), ensuring that data models and reporting structures are aligned with strategic objectives. Develop and maintain dashboards and reports that provide real-time insight into business performance metrics.
Business Analysis and Problem-Solving:
Work backward from business objectives and key performance indicators to determine data requirements and inform data architecture decisions. Act as a bridge between technical teams and business users, translating analytical findings into actionable business strategies. Ensure that reporting tools and analytics solutions effectively support evidence-based decision-making across the organization.
Continuous Improvement and Innovation:
Evaluate and recommend emerging technologies and methodologies for data analytics and business intelligence. Drive process improvements in data management, analytics, and reporting to increase efficiency and accuracy. Mentor and guide junior data professionals, fostering a culture of knowledge sharing and technical excellence.
Governance and Compliance:
Implement data governance frameworks to ensure compliance with regulatory standards and company policies. Establish and enforce data security protocols, access controls, and audit mechanisms. Document data flows, architectures, and lineage to support transparency and traceability.
Required Qualifications
Bachelor’s or Master’s degree in Computer Science, Information Systems, Mathematics, Statistics, or a related field. 10–15 years of progressive experience in data analytics, database development, and business intelligence. Demonstrated expertise in Microsoft data platforms and tools (SQL Server, Azure, Power BI, SSIS, SSRS, SSAS, etc.). Extensive experience designing data models, normalization, and integrating data from diverse sources. Strong understanding of relational databases, data warehousing concepts, ETL best practices, and reporting frameworks. Advanced proficiency with SQL, DAX, and data visualization tools. Proven ability to translate business requirements into technical specifications and actionable solutions. Exceptional analytical, problem-solving, and critical thinking skills. Excellent communication skills, with the ability to articulate complex technical concepts to non-technical stakeholders. Experience leading or mentoring technical teams is highly desirable.
Preferred Skills And Attributes
Experience with cloud-based data platforms, particularly Microsoft Azure Data Services. Familiarity with data governance, privacy, and compliance standards (GDPR, HIPAA, etc.). Exposure to advanced analytics, machine learning, or AI-driven business insights. Project management experience in agile or iterative development environments. Certifications in Microsoft data analytics or related technologies (e.g., Microsoft Certified: Azure Data Engineer Associate, Power BI Certification).
Analytical Approach and Business Alignment
At the heart of this role is the ability to view data through a business lens—working backward from key performance indicators to determine the data structures and processes needed to surface actionable insights. The successful candidate will possess a strategic mindset, balancing deep technical expertise with a clear understanding of business priorities. They will demonstrate an ability to normalize, cleanse, and enrich data from disparate sources, ensuring that reporting solutions provide meaningful, accurate, and timely information.
This position offers the opportunity to play a vital role in shaping the organization’s data-driven culture. You will have direct influence on how data is captured, structured, and leveraged to achieve business objectives, driving both operational efficiency and competitive advantage. Seniority level
Seniority level Mid-Senior level Employment type
Employment type Full-time Job function
Job function Engineering and Information Technology Industries Legal Services Referrals increase your chances of interviewing at U.S. LawShield by 2x Sign in to set job alerts for “Senior Data Architect” roles.
Houston, TX $165,000.00-$230,000.00 1 week ago Houston, TX $130,000.00-$150,000.00 1 month ago Jenkins Architect with CI/CD - 100% Remote
Architect - Strategic Data Intelligence (Time & Labor)
Greater Houston $84,127.00-$138,810.00 5 days ago Houston, TX $102,400.00-$204,100.00 2 weeks ago Houston, TX $171,000.00-$190,000.00 4 days ago Houston, TX $130,000.00-$145,000.00 3 days ago Houston, TX $160,000.00-$175,000.00 1 day ago Houston, TX $135,000.00-$165,000.00 2 weeks ago Application Modernization Solutions Architect
We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.
#J-18808-Ljbffr
Today, we provide coverage in 46 states and have proudly served more than 2 million people in their self-defense journey. Ready to join our driven and talented individuals who care about protecting the rights of responsible self-defenders?
We are seeking a highly experienced and analytical Data Analytics Architect with a proven track record in designing, building, and optimizing databases and data warehouses. The ideal candidate will have 10–15 years of hands-on experience in data management, analytics, and reporting, with a strong preference for expertise in Microsoft-based toolsets and technologies. This individual will work closely with business leaders to identify key business indicators, normalize and integrate data from disparate sources, and deliver actionable insights through advanced reporting solutions.
Key Responsibilities
Database and Data Warehouse Architecture:
O Design, build, and maintain robust databases and data warehouse architectures optimized for analytics and reporting.
Ensure scalability, security, and performance across all data storage solutions. Manage schema design, indexing strategies, and ETL (Extract, Transform, Load) processes using best practices.
Data Integration and Normalization:
Analyze and understand data from multiple heterogeneous sources (e.g., ERP, CRM, transactional, third-party). Develop and implement normalization frameworks to standardize data structures for reporting and analytics. Create data pipelines that ensure data quality, integrity, and consistency across the business.
Analytics and Reporting:
Leverage Microsoft analytics tools (such as SQL Server, Power BI, Azure Synapse Analytics, SSIS, SSRS, and SSAS) to deliver dynamic reporting and visualizations. Collaborate with business stakeholders to identify and define key business indicators (KBIs), ensuring that data models and reporting structures are aligned with strategic objectives. Develop and maintain dashboards and reports that provide real-time insight into business performance metrics.
Business Analysis and Problem-Solving:
Work backward from business objectives and key performance indicators to determine data requirements and inform data architecture decisions. Act as a bridge between technical teams and business users, translating analytical findings into actionable business strategies. Ensure that reporting tools and analytics solutions effectively support evidence-based decision-making across the organization.
Continuous Improvement and Innovation:
Evaluate and recommend emerging technologies and methodologies for data analytics and business intelligence. Drive process improvements in data management, analytics, and reporting to increase efficiency and accuracy. Mentor and guide junior data professionals, fostering a culture of knowledge sharing and technical excellence.
Governance and Compliance:
Implement data governance frameworks to ensure compliance with regulatory standards and company policies. Establish and enforce data security protocols, access controls, and audit mechanisms. Document data flows, architectures, and lineage to support transparency and traceability.
Required Qualifications
Bachelor’s or Master’s degree in Computer Science, Information Systems, Mathematics, Statistics, or a related field. 10–15 years of progressive experience in data analytics, database development, and business intelligence. Demonstrated expertise in Microsoft data platforms and tools (SQL Server, Azure, Power BI, SSIS, SSRS, SSAS, etc.). Extensive experience designing data models, normalization, and integrating data from diverse sources. Strong understanding of relational databases, data warehousing concepts, ETL best practices, and reporting frameworks. Advanced proficiency with SQL, DAX, and data visualization tools. Proven ability to translate business requirements into technical specifications and actionable solutions. Exceptional analytical, problem-solving, and critical thinking skills. Excellent communication skills, with the ability to articulate complex technical concepts to non-technical stakeholders. Experience leading or mentoring technical teams is highly desirable.
Preferred Skills And Attributes
Experience with cloud-based data platforms, particularly Microsoft Azure Data Services. Familiarity with data governance, privacy, and compliance standards (GDPR, HIPAA, etc.). Exposure to advanced analytics, machine learning, or AI-driven business insights. Project management experience in agile or iterative development environments. Certifications in Microsoft data analytics or related technologies (e.g., Microsoft Certified: Azure Data Engineer Associate, Power BI Certification).
Analytical Approach and Business Alignment
At the heart of this role is the ability to view data through a business lens—working backward from key performance indicators to determine the data structures and processes needed to surface actionable insights. The successful candidate will possess a strategic mindset, balancing deep technical expertise with a clear understanding of business priorities. They will demonstrate an ability to normalize, cleanse, and enrich data from disparate sources, ensuring that reporting solutions provide meaningful, accurate, and timely information.
This position offers the opportunity to play a vital role in shaping the organization’s data-driven culture. You will have direct influence on how data is captured, structured, and leveraged to achieve business objectives, driving both operational efficiency and competitive advantage. Seniority level
Seniority level Mid-Senior level Employment type
Employment type Full-time Job function
Job function Engineering and Information Technology Industries Legal Services Referrals increase your chances of interviewing at U.S. LawShield by 2x Sign in to set job alerts for “Senior Data Architect” roles.
Houston, TX $165,000.00-$230,000.00 1 week ago Houston, TX $130,000.00-$150,000.00 1 month ago Jenkins Architect with CI/CD - 100% Remote
Architect - Strategic Data Intelligence (Time & Labor)
Greater Houston $84,127.00-$138,810.00 5 days ago Houston, TX $102,400.00-$204,100.00 2 weeks ago Houston, TX $171,000.00-$190,000.00 4 days ago Houston, TX $130,000.00-$145,000.00 3 days ago Houston, TX $160,000.00-$175,000.00 1 day ago Houston, TX $135,000.00-$165,000.00 2 weeks ago Application Modernization Solutions Architect
We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.
#J-18808-Ljbffr