Microsoft SQL Server Database Analyst – Facet Interactive – Full Job Description

Company: Facet Interactive
Location: Remote
Job Type: Full-time
Salary: ₹24,93,658 – ₹33,24,877 a year

Job Purpose: The Microsoft SQL Server Database Analyst is responsible for developing, deploying, and optimizing SQL Server queries, managing data modeling workflows, and building Power BI reports for internal and client projects. The Analyst collaborates with stakeholders, solutions architects, and developers to deliver impactful analytics, leveraging manufacturing ERP data (strongly preferred Sage 500 ERP experience) to enhance performance management, profitability, and manufacturing efficiency analyses. The Analyst will also integrate AI-assisted coding tools (Amazon Q Developer, GitHub Copilot, etc.) into workflow processes to maximize productivity. The Analyst is responsible for robust documentation, daily communication, and remote collaboration, ensuring clarity and transparency in delivery.

Responsibilities:

• Develop Understanding of Business Context: The Database Analyst is responsible for reviewing analytics and reporting requests thoroughly, actively raising questions to understand the underlying business objectives and required analytical insights.
• Development Estimates: Works closely with Solutions Architects and stakeholders to provide comprehensive estimates, identify and mitigate risks proactively, and ensure accurate, timely delivery of data analysis and reporting tasks.
• Development Estimate Risk: Analyst must effectively communicate any potential deviation from original estimates promptly upon identification.
• SQL Server Development: Develops and optimizes SQL queries, stored procedures, and database models, adhering to Microsoft SQL Server best practices, ensuring performance, security, and maintainability. Understands on-prem SQL Server deployment standards and performance management practices, employing efficient query design, indexing strategies, and proper normalization techniques.
• Power BI Development: Builds, maintains, and refines highly effective, visually compelling dashboards and reports in Power BI, utilizing DAX formulas, Power Query transformations, and advanced data visualization techniques.
• Technical Architecture: Delivers succinct summaries of the technical architecture and analytical approaches for complex Epics or Stories as needed, clearly documenting ERP data modeling strategies and analytics workflows.
• AI-assisted Development: Integrates AI-driven coding assistance tools (e.g., Amazon Q Developer, GitHub Copilot) into SQL Server and Power BI workflows to enhance productivity, code quality, and analytical insights.
• Release Management: Responsible for reviewing, testing, documenting release notes, and deploying analytical solutions into production environments. Ensures smooth, stable deployments with minimal risk.
• DevOps: Adopts Facet’s current data engineering, deployment, and local development standards, continuously improving and optimizing operations across the analytics portfolio, particularly leveraging automation, linters (e.g., sqlfluff), and other best practices.
• Standard Operating Procedures (SOPs): Demonstrates in-depth understanding of Facet’s analytics and development SOPs, contributes actively to SOP refinement, and consistently produces detailed documentation to build organizational knowledge.
• Risk Management: Collaborates with principals and technical architects to proactively identify, document, and address analytical, technical debt, or operational risks. Actively participates in ticket grooming for upcoming work.

Outcomes: Specific Measures of Success

• 90% Standardization of SQL Server and Power BI Deployment Operations across all client and internal projects within 3 months.
• 50%+ Reduction in manual intervention for recurring reporting tasks through effective use of automation and AI-assisted tools within 6 months.
• Establish a robust manufacturing-focused analytics framework (especially with Sage 500 ERP), driving measurable improvements in profitability, cost-based analysis accuracy, and manufacturing efficiency.
• Reduce overall project delivery timelines through improved documentation, communication, and analytics standardization.

Role Competencies:

• Accurate and comprehensive estimation workflow for SQL Server analytics and Power BI development, including clear confidence assessments.
• Thorough risk documentation and strategic risk mitigation planning (including addressing technical debt, analytical gaps, and data quality issues).

Client Expectations Management:

• Challenge analytical requirements within assigned project teams that are not clearly tied to measurable business results, such as profitability or efficiency improvements.
• Work collaboratively with L3/L4 team members to prioritize analytics tasks based on business impact.
• Clearly communicate limitations or boundaries of available data sources, including ERP systems, when defining analytical scopes.
• Consistently position Facet as a trusted analytics partner, never compromising the delivery of high-value analytical insights solely for backlog management purposes.

Remote Communication & Documentation Excellence:

• Daily stand-ups and stand-downs via Slack, Loom, or Zoom, effectively over-communicating progress, issues, and achievements.
• Timely and accurate management of Jira tickets, Harvest time entry, and internal documentation standards.

Technical Skills:

• Database and SQL Development:
  • Microsoft SQL Server (On-Prem) Administration and Optimization
  • Advanced SQL Query Development and Optimization
  • Database Schema and Data Modeling Best Practices (Sage 500 ERP preferred)
• Analytics & Visualization:
  • Expert-level Power BI Reporting and Dashboard Development
  • Advanced DAX and Power Query Formulations
  • Demonstrable portfolio of data visualization expertise
• Development & DevOps Tools:
  • AI-assisted coding tools (Amazon Q Developer, GitHub Copilot, etc.)
  • Familiarity with Next.js and React for frontend analytics integration
  • SQL Linting tools (sqlfluff experience preferred)
  • Familiarity with data transformation tools (dbt – Data Build Tool)
• Manufacturing & ERP Analytics:
  • Cost-based Analysis
  • Profitability Analysis
  • Manufacturing Efficiency Metrics
  • Performance Management Analytics
• Documentation & Communication:
  • Exceptional written communication, technical documentation, and collaborative workflow management skills
  • High literacy and accuracy in development and analytical documentation processes

Additional Preferred Competencies:

• Experience contributing to or leveraging open-source projects
• Familiarity with CI/CD workflows, version control (Git), and automation scripting (Python, PowerShell)

Cultural Fit: Facet’s team abide by 7 pillars, to learn more, check out: Growth – Clear data insights and models for repeatable success are our keys to growth. Over-communicate – We’re only as good as the knowledge we share with others. Overanalyze – The data you don’t have is just as important as the data you see. We model for success and mind the gap between expected and unexpected outcomes. Peers, Not Peons – Our culture is defined by the partners with which we surround ourselves. Leverage Ideas, Not Time – We seek to waste less time by building the future processes of tomorrow. We ceaselessly seek to answer the question: if this was fixed tomorrow, what would it look like? Locally Optimize, Globally Innovate – Through data insights and analysis we can find local maximums in performance, but to grow to new heights we must continuously test innovative ideas. Extreme Ownership – We seek to empower all team members to own their projects and maximize cross-functional skill sets.

Job Type: Full-time

Pay: ₹2,493,658.00 – ₹3,324,877.00 per year

Benefits:

• Flexible schedule
• Health insurance
• Paid sick time
• Paid time off

Schedule:

• Monday to Friday
• US shift

Application Question(s):

• What is your experience with ERPs?
• What is your experience with Sage?

Work Location: Remote

Expected Start Date: 07/04/2025