MSSQL Database Admin/Developer (Onsite) 189389
# of positions : 1 Salary: 96K MAX
Location : Irving, TX
Duration: Permanent
Job Description:
Mandatory Skills MS SQL, Python, Tableau, QlikView
Overview
Highly skilled and experienced Lead Developer with a strong focus on data analytics. The ideal candidate will be responsible for the design, development, and implementation of data-driven solutions, ensuring the delivery of high-quality, scalable, and robust applications. This role requires a blend of technical expertise and a passion for leveraging data to drive business insights.
Responsibilities
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.
Key Skills
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.