Sign up to access all features of our service.
  • Job search
  • Favorites
  • Create a CV
    New
  • Salaries
  • Subscriptions

Database Administrator - ETL, Python, SQL

Software Technology Inc

Database Analyst The customer is seeking a Database Analyst to create tables, migrate data, configure ETL pipelines, and create backup loads. The Database Analyst position will provide consulting services in support of the creation of a Data Warehouse for the Property Tax Oversight Program. Scope of Work Required consultant experience provided by Contractor, shall include: 5 years of experience with Snowflake data warehouse. 3 years of experience with no/low code ETL tools/platforms (e.g., Matillion, Talend, Informatica). 3 years of experience performing ETL processes using code (e.g. Python, SQL). Strong experience with data integration, data quality, and data governance. Strong experience with relational databases, SQL, and data modeling. Strong experience working collaboratively with business analysts, developers, and non-technical end users related to data warehousing. Writing ETL Pipelines ETL Tool Selection: Provide alternatives and advantages/disadvantages to aid in selection of a no/low code ETL platform/tool. Design and Develop ETL Pipelines: Create, optimize, and maintain ETL pipelines to migrate data from various sources (Oracle, MS- SQL, flat files) to the target Snowflake data warehouse. Utilize a combination of coding (Python, SQL, etc.) and no/low-code tools (e.g., Azure Data Factory, Talend, Informatica) to develop ETL processes that meet data integration needs. Data Transformation and Validation: Apply transformations to cleanse, filter, join, and aggregate data from the source systems. Ensure data quality by implementing validation rules to verify data correctness and completeness before loading into Snowflake. Source-to-Target Mapping: Create detailed source-to-target mappings to ensure accurate transformation from source systems (Oracle, MS-SQL) into Snowflake. Ensure solution provides data quality, consistency, and integrity throughout the ETL process. Automation and Scheduling: Work with other resources to automate the ETL processes to run at scheduled intervals based on specific needs. Monitor and optimize ETL jobs to ensure they run efficiently and on time. Error Handling and Troubleshooting: Implement error detection, logging, and alerting mechanisms within the ETL pipelines. Troubleshoot ETL failures, identify root causes, and make necessary adjustments to ensure pipeline stability. Performance Optimization: Tune ETL processes for performance improvements, minimizing resource consumption and ensuring fast data migration. Testing: Develop test cases for ETL processes and data pipelines to ensure they meet business requirements and are free of errors. Perform unit testing of ETL pipelines. Creating and Maintaining Snowflake Tables Table Design and Creation: Design, create, and optimize Snowflake tables to store transformed data, ensuring proper indexing, clustering, and partitioning strategies. Work with business stakeholders to understand data requirements and create tables that meet the business needs (e.g., fact and dimension tables, data marts). Schema Management: Maintain and manage Snowflake schema to ensure efficient querying and reporting. Monitor schema changes and manage data migrations across environments (development, staging, production). Data Modeling: Develop and maintain logical and physical data models in Snowflake, ensuring they align with business requirements and reporting needs. Support dimensional data modeling and star/snowflake schema design to facilitate reporting and analysis. Data Governance and Security: Implement data governance standards and policies to ensure data integrity and security. Define roles and access controls within Snowflake to restrict access to sensitive data. Data Quality and Consistency: Implement data quality checks within Snowflake to ensure that the data loaded into tables meets the necessary standards for reporting and analytics. Perform regular data audits to check for discrepancies or inconsistencies. Collaboration / Documentation Collaboration: Work closely with business stakeholders, business analysts, data architect, and IT teams to gather requirements and provide technical solutions. Provide training, support, and documentation to end-users and technical teams to provide for long-term ongoing maintenance and support of the solutions. Regularly interface with and provide status updates to other project resources including project manager, business analysts, data warehouse architect, and key stakeholders. Work diligently to ensure completion of project goals by the end of the project. Documentation: Document ETL processes, Snowflake schema designs, and data pipelines for future reference and team knowledge sharing. Maintain clear documentation on data definitions, transformation rules, and data quality standards. Education/Certifications: Bachelor's degree in Computer Science, Information Technology, Data Science, or related field. Master's degree preferred. Required Skills: API, ETL, Python, SQL Software Technology Inc

Vacancy posted 2 days ago
Similar jobs that could be interesting for youBased on the Database Administrator - ETL, Python, SQL in Tallahassee, FL vacancy
  • $59 - $69 per hour

    DescriptionKforce has a client in Durham, NC that is seeking a Database Data Engineer - PL SQL ETL Informatica.Requirements* 7+ years of experience in...  ..., Data Warehouse, etc.* Beginner level proficiency in Python, REST API and AWS* You are passionate about delivering high... 
    SQL
    Python

    KForce

    Tallahassee, FL
    2 days ago
  •  ...currently seeking a Senior Engineer, Senior Database Administrator to join our Digital Nexus technology...  ...detailed root-cause analyses on SQL statements and system performance bottlenecksImplement...  ...or familiarity with scripting in Python, PowerShell, or PySpark for task... 
    SQL
    Python
    H1b
    Local area
    Afternoon shift

    KPMG

    Tallahassee, FL
    2 days ago
  • Database Administrator - ( Power Bi And Sql) Job Location: Tallahassee, FL Job Duration: 11-month contract + extension Job Overview: The Database Administrator...  ...and present them the design results. Create/maintain ETL architecture and provide strategy related to data... 
    SQL
    Contract work
    Work experience placement

    Samprasoft

    Tallahassee, FL
    2 days ago
  •  ...Database Administrator Contract: 12-Months (No C2C or Third-Party Vendors) Location: Tallahassee...  ...have strong expertise in Microsoft SQL Server Azure SQL and related Azure services...  ...maintenance. ~ Experience with ETL/ELT processes data integration Azure services... 
    SQL
    Full time
    Contract work

    Genius Road

    Tallahassee, FL
    2 days ago
  • Job Summary: We are seeking an experienced ETL & Dashboard Developer to design, develop,...  ...and ETL processes using Qlik Sense, SQL Server, SSIS, and Azure Data Factory . The...  ...& Reporting: Create ad-hoc reports, OLAP database queries, and decision-support systems (DSS... 
    SQL

    Apex Informatics

    Tallahassee, FL
    2 days ago
  • $75.64 - $80.64 per hour

     ...(SOW) to support enterprise Microsoft SQL Server and Azure SQL databases. SCOPE: The candidate will provide experienced Senior Database Administrator services to perform the following: Manage...  ...using SQL Server, Azure services, ETL/ELT tools, APIs, files, and other approved... 
    SQL
    Temporary work
    For contractors
    Work experience placement
    Local area

    CYNET SYSTEMS

    Tallahassee, FL
    7 days ago
  • Senior Database Administrator - SQL Server/Azure This position is for a Senior Database Administrator with experience in SQL Server and Azure. The...  ...supporting data transformation and integration processes, including ETL/ELT, data mapping, validation, scheduling, and error... 
    SQL
    Remote job
    Temporary work

    Vitaver and Associates, Inc. (dba Vitaver Staffing)

    Tallahassee, FL
    2 days ago
  • $75 - $80 per hour

    Database Administrator Req number: R8963 Employment type: Full time Worksite flexibility: Onsite...  ...support mission-critical Microsoft SQL Server and Azure SQL environments, ensuring...  ...using SQL Server, Azure services, ETL/ELT workflows, APIs, file-based integrations... 
    SQL
    Hourly pay
    Full time
    Contract work
    Apprenticeship
    Work experience placement
    Work at office
    Local area
    Remote work
    Worldwide

    CAI

    Tallahassee, FL
    2 days ago
  •  ...transformation logic, building ETL pipelines, and improving how data...  ...or a similar role Strong SQL skills, with the ability to write...  ...an advantage Familiarity with Python or R is beneficial Experience working with relational databases and large datasets Proven ability... 
    SQL
    Python

    H Squared LLC

    Tallahassee, FL
    4 days ago
  •  ...SQL DBALocation: Tallahassee, FL 32301Duration: 10 monthsExperience: The candidate must have skill and 15 years combined experience in database administration for the following database platforms:1. DB2 for z/OS2. SQL Server 2008R2, 20123. Oracle 10g and above4. Experience... 
    SQL

    Anveta

    Tallahassee, FL
    2 days ago
  •  ...New position: SQL DBA Location: OIT Application Services Barry Building 3185 S. Blair Stone Rd Tallahassee...  ...must have skill and 15 years combined experience in database administration for the following database platforms: 1. DB2 for z/OS... 
    SQL

    Anveta

    Tallahassee, FL
    2 days ago
  • Database Administrator - Advanced Location: Tallahassee, FL 32301 Work Arrangement: 100% Onsite - No Telework/Remote Option IMPORTANT LOCATION...  ...COBOL, JCL, CICS, RACF, ISPF, ASG Scheduler, Oracle, Microsoft SQL Server, Windows Server, SSIS, SSRS, and Azure is highly... 
    SQL
    Remote work
    Relocation

    InstantServe LLC

    Tallahassee, FL
    2 days ago
  • $123.37k - $136.06k

     ...collaborative environment. Join our Technology Team as a Senior Database Administrator located in various offices.We are seeking a professional who...  ...architecting, administering and optimizing all enterprise SQL Server databases, ensuring security, reliability, and... 
    SQL
    Full time
    Temporary work
    Remote work
    Flexible hours

    Greenberg Traurig LLP

    Tallahassee, FL
    3 days ago
  • We are seeking an experienced Database Administrator to support, maintain, and optimize enterprise database environments. The ideal candidate will...  ...and performance optimization, and proficiency in SQL development and troubleshooting. Experience working with multiple... 
    SQL
    Work experience placement

    Robert Half

    Tallahassee, FL
    3 days ago
  • $86k - $138k

     ...the world safe and secure.ResponsibilitiesPeraton requires Database Administrators to support the Special Operation Command Information Technology...  .... This position requires knowledge and experience with SQL Server, and prefers familiarity with other major database management... 
    SQL
    Contract work
    Temporary work
    Shift work

    Peraton Corporation

    Tallahassee, FL
    3 days ago
  •  ...technical data is highly desired.Experience building back-end services and APIs using Python, Java, Node.js, .NET, or similar.Familiarity with databases such as PostgreSQL, MySQL, SQL Server, DynamoDB, or other relational/non-relational data stores.Prior field assignment... 
    SQL
    Python

    L3Harris Technologies

    Tallahassee, FL
    3 days ago
  •  ...attention to detail Bonus: Knowledge of usability testing methods and tools Basic programming or scripting experience in Python, SQL, or JavaScript Experience with Sitecore or other Content Management Systems Company Description At Beckman Coulter... 
    SQL
    Python
    Remote job
    Internship
    Worldwide

    Danaher

    Tallahassee, FL
    3 days ago
  •  ...structure to complex problems. The role involves writing complex SQL to access data in our warehouse, while also building and...  ...Proficiency in SQL for data manipulation and analysis. Comfortable with Python. Experience working within data platforms like Databricks/... 
    SQL
    Python
    Full time

    FocusKPI

    Tallahassee, FL
    12 hours ago
  •  ...experience in Synapse Analytics, Dedicated SQL Pools, Azure SQL Database, and Azure Managed Instance. 2. 5+...  ...with programming languages such as Python or Scala. 1+ years of experience in Salesforce...  ..., and security. Data Integration and ETL Processes: Develop and manage ETL (... 
    SQL
    Python
    Work experience placement

    3B Staffing LLC

    Tallahassee, FL
    2 days ago
  • Position: Database Administrator, C. Advanced Location: Tallahassee, FL 32301 (Onsite) Duration: 8+ Months Job Description: Education Bachelor...  ...for the following database platforms: DB2 for z/OS SQL Server 2008R2, 2012 Oracle 10g and above Experience with the... 
    SQL
    Work experience placement
    Work at office

    My3Tech Inc

    Tallahassee, FL
    2 days ago
  • Job Title: Database Administrator C. Advanced Job ID / Solicitation No.: Job 1440 / 80101507-23-STC-ITSA Client: Florida Department of Transportation...  ...monitoring, operational administration, documentation, SQL code reviews, and technical staff mentoring. II. Primary Job... 
    SQL
    Work experience placement

    My3Tech Inc

    Tallahassee, FL
    2 days ago
  • Database Administrator Job Location: Tallahassee, FL (Hybrid-3 days/week onsite) Job Duration: Contract through June + annual extension Job Overview...  ...administration procedures and documentation. Perform SQL Code reviews. Assist with training/mentoring other technical... 
    SQL
    Contract work
    3 days per week

    Samprasoft

    Tallahassee, FL
    2 days ago
  • Database Administrator The candidate in this position will be responsible for database administration of various database platforms including DB2 for z/OS, Oracle, MS SQL Server, Azure SQL, and MongoDB. The candidate will be the lead database administrator for Oracle databases... 
    SQL

    Samprasoft

    Tallahassee, FL
    2 days ago
  • Database Administrator Arete Technologies, Inc. offers a set of innovative Consulting and Outsourcing services, bridging the gap between requirements...  ...Administrator using the following database platforms: SQL Server 2008R2 and 2012 AzureSQL Oracle 10g and above Database... 
    SQL
    Local area
    Worldwide

    Arete Technologies Inc

    Tallahassee, FL
    2 days ago
  •  ...custom software applications and databases, implements enhancements to...  ...ORMS including Entity Framework, SQL Server. Eight (8) + years of...  ...NoSQL Databases (MongoDB), Python, and GIS frameworks is highly...  ...replication experience leveraging ETL solutions will be given... 
    SQL
    Python
    Work experience placement
    Work at office

    Cedent

    Tallahassee, FL
    1 day ago
  • Job Title: Database Administrator (Advanced) Experience: 5+ years 4 Scope of Services The DBA team is responsible for ensuring the application...  ...for the following database platforms: Expert in SQL Server 2012, and above Oracle 10g and above Experience with... 
    SQL
    Work experience placement

    3B Staffing LLC

    Tallahassee, FL
    2 days ago
  • $49.66k

     ...position with responsibilities that include installing, administering, developing, maintaining, upgrading, and supporting Microsoft SQL instances. Responsibilities also include knowledge and use of SQL Server management tools, SQL Server Integration Services (SSIS), data... 
    SQL
    Full time
    Part time
    Work at office
    Monday to Friday
    Flexible hours

    Florida Legislature

    Tallahassee, FL
    2 days ago
  • Database Administrator Onsite, C2C Must complete the following Education, Experience, and Skills Matrices Education - Degree / Date of Graduation...  ...platforms: 1. DB2 for z/OS 2. Oracle 10g and above 3. MS SQL Server 4. Azure SQL Additional Experience: - Years’ Experience... 
    SQL
    Work experience placement
    Work at office

    Software Technology Inc

    Tallahassee, FL
    2 days ago
  • Title: Database Administrator Location: Tallahassee, FL Job Description: Education: Bachelor's or master's degree in computer science, Information...  ...platforms: 1. Experience with IBM DB2 2. Proficient with SQL Server 2016 and above 3. Proficient with Oracle 19c and... 
    SQL
    Work experience placement
    Work at office

    Apex Informatics

    Tallahassee, FL
    2 days ago
  • $120k - $140k

     ...technical success. Build advanced analytical models using SQL, Python, and Excel to demonstrate product value. Monitor industry...  ...​ ~ B.S or B.A degree in Engineering, Business administration or related field required. ~3+ years of experience in a solutions... 
    SQL
    Python
    Remote job
    Full time
    H1b

    Aperia Technologies

    Tallahassee, FL
    12 hours ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to Database Administrator - ETL, Python, SQL. Be the first to apply!