ETL/Database/.Net developer (Remote)

Scoring:

• 20% - Cost
• 70% -Expertise with designing, developing and managing Mirosoft SQL Server databases; Expertise with designing, developing and maintaining ETL Processes and managing data; Expertise with developing, testing and maintaining .Net applications
• 10% - Integrating and supporting third party software

Preferred/required skills:

• Expertise with designing, developing and managing Mirosoft SQL Server databases
• Expertise with designing, developing and maintaining ETL Processes and managing data
• Expertise with developing, testing and maintaining .Net applications
• Integrating and supporting third party software.

Key Responsibilities:

• Writes and optimizes complex SQL queries, stored procedures, triggers, and functions.
• Designs database schemas, tables, and relationships to support applications.
• Ensures data integrity and efficient data retrieval for applications.
• Collaborates with software developers to integrate databases with applications.
• May work on data modeling and performance tuning for specific use cases.
• Performs audits on data retention and data logging strategies.
• Cross server login authentication for production or test users
• Skills: Strong programming skills (e.g., SQL, T-SQL).
• Knowledge of database design principles and normalization.
• Familiarity with application development and APIs.
• Tools: SQL Server 2022
• Focus Area: Building and optimizing databases for application functionality and security.

• Data Integration: Integrate data from multiple sources, ensuring consistency, accuracy, and reliability.
• Optimize Performance: Tune ETL processes for efficiency, scalability, and performance, minimizing processing time and resource usage.
• Data Quality Assurance: Implement data validation, cleansing, and error-handling mechanisms to ensure high-quality data.
• Collaborate with Stakeholders: Work with data analysts, data scientists, and business teams to understand data requirements and deliver solutions.
• Maintain and Monitor ETL Jobs: Schedule, monitor, and troubleshoot ETL workflows, ensuring timely and accurate data delivery.
• Documentation: Document ETL processes, data mappings, and workflows for reference and compliance.
• Stay Updated: Keep abreast of new ETL tools, technologies, and best practices to improve processes.
• Technical Skills: Strong SQL knowledge for querying and manipulating data.
• Experience with databases (e.g., SQL Server 2022, Microsoft Access).
• Expertise with programming/scripting languages (e.g., C#) often used for data transformation or manipulation.
• Soft Skills: Strong problem-solving and analytical skills.
• Attention to detail and commitment to data accuracy.
• Effective communication to collaborate with technical and non-technical teams.

• Help and mentor junior .Net developers
• Write clean, efficient, and well-documented code following best practices.
• Collaborate with product managers, designers, and other developers to define requirements and deliver solutions.
• Troubleshoot, debug, and optimize existing systems.
• Participate in code reviews and ensure adherence to coding standards.
• Stay updated on emerging technologies and propose improvements to processes and tools.
• Third Party Software Support Engineer A third-party software support engineer provides technical assistance and troubleshooting for software developed by an external vendor or company, rather than in-house. Their key responsibilities include:
• Diagnosing Issues: Investigating and resolving software-related problems reported by users, often by analyzing logs, error messages, or user feedback.
• Customer Support: Communicating with clients (via email, phone, or ticketing systems) to understand issues, provide solutions, or guide them through fixes.
• Liaising with Vendors: Collaborating with the third-party software provider to escalate complex issues, report bugs, or request patches/updates.
• Configuration and Integration: Assisting with software setup, configuration, or integration into existing systems to ensure compatibility and functionality.
• Documentation: Creating or maintaining knowledge bases, FAQs, or guides to help users troubleshoot common issues.
• Testing and Updates: Verifying software updates or patches from the vendor and ensuring they resolve issues without introducing new ones.
• Training: Occasionally training end-users or internal teams on how to use the software effectively.
• They act as a bridge between the end-user, their organization, and the software vendor, ensuring smooth operation and user satisfaction. Skills typically include strong problem-solving, communication, and knowledge of the specific software, along with familiarity with IT systems and sometimes coding or scripting for custom solutions.

Cleo Consulting is an equal opportunity employer (Minorities/Women/Veterans/Disabled)