MS BI Developer/ SQL Server Developer/ SSIS Developer

Job Position: MS BI Developer/ SQL Server Developer/ SSIS Developer Job Location: Addison, TX (Onsite) Job Duration: Fulltime Job Description: Design and optimize SQL Server databases-schemas, indexes, views, stored procedures, and performant T SQL. Develop and maintain SSIS ETL pipelines for data ingestion, transformation, validation, scheduling, and error handling. Implement secure, scalable REST APIs with ASP.NET Core, including authentication/authorization (JWT/OAuth) and input validation. Build modern Angular (18/19) UIs using standalone components, reactive forms, interceptors, guards, and RxJS/Signals for state. Integrate Angular front-end with .NET back-end, ensuring secure token handling, robust error management, and efficient data flows. Apply architectural best practices-SOLID, clean architecture, layered/microservices patterns, and reusable UI/component design. Ensure data integrity and governance with auditing, logging, role-based access, and compliance for sensitive data (PII). Optimize performance end-to-end-query tuning, ETL throughput, API latency, caching, pagination, and UI rendering. Automate builds, tests, and deployments (CI/CD) using pipelines, unit/integration testing (xUnit/Jest/Cypress), and static analysis. Monitor and observe systems with logging, tracing, metrics, dashboards, alerts, and RCA for incidents across SQL/ETL/API/UI. Manage jobs and operations-SQL Server Agent tasks, maintenance plans, backups/restores, environment migrations (DEV/QA/PROD). Collaborate in Agile/Scrum-participate in ceremonies, refine requirements, estimate work, and maintain delivery commitments. Document solutions thoroughly-ER diagrams, API specs, SSIS runbooks, deployment guides, and operational playbooks. Ensure security-by-design-OWASP practices, parameterized queries, secret management, API versioning, and least-privilege access. Provide production support-triage issues, implement fixes, prevent regressions, and communicate clearly with stakeholders. Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.

Created: 2026-03-04