What are the responsibilities and job description for the MSSQL Database Admin/Developer position at Lorven Technologies Inc.?
Hi,
Our client is looking for an MSSQL Database Admin/Developer in Irving, TX below is the detailed requirement.
Job Title: MSSQL Database Admin/Developer
Location: Irving, TX
Mandatory Skills: MS SQL, Python, Tableau, QlikView
Job Description:
- Bachelor’s degree in related field.
- Data Analytics: Proven experience in data analysis and interpretation of complex datasets.
- Python: Expert-level proficiency in Python, including libraries for data manipulation (e.g., Pandas, NumPy) and data visualization.
- Tableau: Advanced skills in designing, developing, and maintaining interactive and insightful dashboards and reports.
- QlikView/Qlik Sense: Solid experience in developing and deploying applications, dashboards, and reports using QlikView or Qlik Sense.
- Migration Experience: Preferred experience in migrating from Qlik to Tableau.
- Strong DB Skills: Extensive experience with relational databases, including SQL query optimization, database design, and administration.
- Microsoft SQL Server experience is highly preferred.
- Kafka: Experience working with Kafka on both publisher and Reader side using Python
- SSIS Packages: Proven experience with SQL Server Integration Services (SSIS) for ETL processes.
- Migration Experience: Preferred experience in migrating legacy data integration solutions (e.g., SSIS) to modern platforms or languages like Python.
- Excellent problem-solving, analytical, and critical thinking skills.
- Strong communication and interpersonal skills, with the ability to effectively collaborate with cross-functional teams and present technical concepts to non-technical stakeholders.
- Lead the technical design, development, and implementation of data analytics solutions.
- Architect and optimize data pipelines, ETL processes, and data warehousing solutions.
- Develop, test, and deploy applications using Python for data processing, analysis, and reporting.
- Design and create interactive dashboards and reports using Tableau, translating complex data into actionable insights.
- Utilize strong database skills to manage, query, and optimize data in various database systems, with a preference for Microsoft SQL Server.
- Develop and maintain reporting and visualization solutions using QlikView/Qlik Sense.
- Collaborate with business stakeholders and other development teams to understand requirements and deliver effective solutions.
- Ensure adherence to best practices in coding, testing, and documentation; perform code reviews and provide constructive feedback to team members.