What are the responsibilities and job description for the Database & Data Engineer position at Lean Marketing?
Database & Data Engineer
National Business Institute (NBI) is a nationwide leader in continuing legal education. For more than 35 years, we’ve delivered thousands of programs — from live seminars to on-demand courses and webinars. Every day, professionals count on NBI to stay sharp, stay compliant, and stay ahead in their practice
Position Overview
The Database & Data Engineer drives the design, performance, and reliability of NBI’s SQL
ecosystem, including Azure SQL environments, data warehouses, and business-critical
systems.
This role focuses on building well-architected, secure, and high-performing database
solutions that support integration across multiple systems and enable teams to turn data into action.
You will design schemas, indexes, and pipelines, proactively optimize queries and performance,
enforce data governance and security standards, and collaborate with analysts, marketers, and
operations teams to implement solutions that power campaigns, reporting, and strategic decisions.
This is not a maintenance role — it’s an opportunity to own, transform, and protect the
databases and integrations that underpin the company’s growth and decision-making.
Why This Role Matters
Key Responsibilities
Qualifications / Experience / Skills
Education: - Bachelor’s degree in Computer Science, Information Systems, Data Engineering, or a
related field — or equivalent practical experience.
Experience: - 5 years in database administration, database engineering, or SQL Server
development, ideally in Microsoft SQL Server and Azure SQL environments. - Proven experience
designing and optimizing schemas, tables, indexes, and queries for scalability, performance, and
reliability. - Hands-on experience monitoring, troubleshooting, and tuning Microsoft SQL Server /
Azure SQL databases. - Experience designing and building data integrations between business
systems using ETL pipelines, APIs, or custom scripts. - Demonstrated commitment to data security,
governance, and compliance. - Experience supporting analysts, marketers, or other teams by
providing database guidance and architectural expertise.
Technical Skills: - Expert in Microsoft SQL Server (MSSQL) and Azure SQL (Managed Instance,
SQL Database, SQL on VMs). - Strong SQL skills — writing and optimizing queries, stored
procedures, and views. - Performance tuning, indexing, and query optimization. - Experience
with integration development: designing and building ETL pipelines, APIs (REST, SOAP,
GraphQL), and system-to-system scripting. - Knowledge of data modeling (normalization, star
schemas, primary/foreign key relationships). - Familiarity with monitoring and performance tools
(SQL Profiler, SQLSentry, Azure monitoring). - Experience with scripting or automation (Python,
PowerShell, or similar). - Version control and deployment experience (e.g., Git, CI/CD workflows).
Soft Skills: - Strong problem-solving and analytical thinking — able to troubleshoot complex
database and integration issues. - Excellent communication skills — translating technical
requirements into actionable solutions for business teams. - Collaborative and approachable — works
effectively across cross-functional teams. - Mentors and supports other developers, helping
enforce best practices and scalable solutions. - Proactive, reliable, and accountable — takes
ownership of database health, performance, and integrity.
Location
Hybrid in Eau Claire, WI — a mix of focused, heads-down work and collaborative team time.
National Business Institute (NBI) is a nationwide leader in continuing legal education. For more than 35 years, we’ve delivered thousands of programs — from live seminars to on-demand courses and webinars. Every day, professionals count on NBI to stay sharp, stay compliant, and stay ahead in their practice
Position Overview
The Database & Data Engineer drives the design, performance, and reliability of NBI’s SQL
ecosystem, including Azure SQL environments, data warehouses, and business-critical
systems.
This role focuses on building well-architected, secure, and high-performing database
solutions that support integration across multiple systems and enable teams to turn data into action.
You will design schemas, indexes, and pipelines, proactively optimize queries and performance,
enforce data governance and security standards, and collaborate with analysts, marketers, and
operations teams to implement solutions that power campaigns, reporting, and strategic decisions.
This is not a maintenance role — it’s an opportunity to own, transform, and protect the
databases and integrations that underpin the company’s growth and decision-making.
Why This Role Matters
- Build well-designed, fast, secure, and scalable database foundations that support all business-critical systems.
- Ensure high-performance, reliable, and optimized SQL Server and Azure SQL databases.
- Design and build integrations between multiple business systems (CRM, marketing platforms, reporting tools) that unify the customer story.
- Provide guidance and architectural expertise for analysts, marketers, and other teams to implement database-driven solutions.
- Proactively monitor, troubleshoot, and tune databases to prevent bottlenecks and ensure system reliability.
- Maintain data security, governance, and integrity across all platforms.
Key Responsibilities
- Database Design & Performance - Design and optimize schemas, tables, indexes, and queriesfor scalability, performance, and reliability. - Monitor, troubleshoot, and tune databases to resolve bottlenecks proactively .- Participate in database migrations, upgrades, and performance tuning across Azure SQL and other environments
- System Integration & Data Unification - Build and maintain ETL pipelines, APIs, and scripts to connect CRM, marketing, reporting, and other platforms. - Ensure data hygiene, identity resolution, and deduplication across systems. - Align data structures to deliver a single source of truth for reporting and analytics.
- Support & Collaboration - Translate business requirements into technical solutions that enable teams to succeed. - Provide guidance and support to other developers and teams implementing queries, reports, or integrations. - Maintain documentation, data dictionaries, and pipeline diagrams for clarity and governance.
- Security & Governance - Enforce database permissions, access controls, and security best practices. - Build monitoring, logging, and error-handling frameworks to ensure system reliability and integrity. - Define and track SLAs/SLIs for data availability, freshness, and accuracy.
Qualifications / Experience / Skills
Education: - Bachelor’s degree in Computer Science, Information Systems, Data Engineering, or a
related field — or equivalent practical experience.
Experience: - 5 years in database administration, database engineering, or SQL Server
development, ideally in Microsoft SQL Server and Azure SQL environments. - Proven experience
designing and optimizing schemas, tables, indexes, and queries for scalability, performance, and
reliability. - Hands-on experience monitoring, troubleshooting, and tuning Microsoft SQL Server /
Azure SQL databases. - Experience designing and building data integrations between business
systems using ETL pipelines, APIs, or custom scripts. - Demonstrated commitment to data security,
governance, and compliance. - Experience supporting analysts, marketers, or other teams by
providing database guidance and architectural expertise.
Technical Skills: - Expert in Microsoft SQL Server (MSSQL) and Azure SQL (Managed Instance,
SQL Database, SQL on VMs). - Strong SQL skills — writing and optimizing queries, stored
procedures, and views. - Performance tuning, indexing, and query optimization. - Experience
with integration development: designing and building ETL pipelines, APIs (REST, SOAP,
GraphQL), and system-to-system scripting. - Knowledge of data modeling (normalization, star
schemas, primary/foreign key relationships). - Familiarity with monitoring and performance tools
(SQL Profiler, SQLSentry, Azure monitoring). - Experience with scripting or automation (Python,
PowerShell, or similar). - Version control and deployment experience (e.g., Git, CI/CD workflows).
Soft Skills: - Strong problem-solving and analytical thinking — able to troubleshoot complex
database and integration issues. - Excellent communication skills — translating technical
requirements into actionable solutions for business teams. - Collaborative and approachable — works
effectively across cross-functional teams. - Mentors and supports other developers, helping
enforce best practices and scalable solutions. - Proactive, reliable, and accountable — takes
ownership of database health, performance, and integrity.
Location
Hybrid in Eau Claire, WI — a mix of focused, heads-down work and collaborative team time.
Powered by JazzHR
nQW3bQg2t7
